My Oracle Support Banner

How Set the Characterset When Using APEX_APPLICATION_INSTALL and SQL*Plus to Import an Application (Doc ID 1329977.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Application Express (formerly HTML DB) - Version and later
Information in this document applies to any platform.


When doing an application import using the GUI APEX interface or through SQL Developer, the application characterset can be selected  from a drop down list. However, when using SQL*Plus with  the APEX_APPLICATION_INSTALL package to set the Workspace, User, etc, there is not an option to set the Character set.

How can you set / change the characterset when doing an APEX application import from SQL*Plus with the APEX_APPLICATION_INSTALL package in order to avoid wrong characters displayed in the imported application?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.