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

Last updated on MARCH 01, 2016

Applies to:

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

Goal


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?


Solution

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 hundreds of Community platforms