To connect from Oracle Forms 6i / Reports 6i to Oracle 10g XE, need to set the database character set as UTF8.
Steps to follow:
1. Connect to the database as SYSDBA
SQL>CONN SYSTEM/MANAGER AS SYSDBA
2. Shutdown the database if running:
SQL>SHUTDOWN IMMEDIATE
3. Start the database in restrict mode:
SQL>STARTUP RESTRICT
4. Change the databse charcter set to UTF8 as follows:
SQL>ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8;
5. Shutdown the database:
SQL>SHUTDOWN IMMEDIATE
6. At last, start the database in normal mode:
SQL>STARTUP
After successfull of these steps, you can connect to the Oracle XE database through Forms 6i or Oracle Reports 6i.
Note: Install Oracle Forms and Reports in different Oracle Home
This is also for Oracle 11g XE.
ReplyDeleteI am using 10g Database and 6i Developer on Windows 7 32 bit. I am unable to use bangle font. Please help me if have any others solution.
ReplyDeleteFor displaying Unicode data in report add as follows:
ReplyDeleteset JAVA_OPTIONS=%JAVA_OPTIONS% -Dfile.encoding=utf8
in the file C:\Oracle\Middleware\user_projects\domains\ClassicDomain\bin\setDomainEnv.cmd
when installing Weblogic with Oracle Report Services.
It will show data stored either NVARCHAR2 or VARCHAR2(NLS_CHARACTERSET AL32UTF8 or UTF8).
For Uploading Unicode data by SQL script through batch file into multiple schemas:
ReplyDelete--------
D:\oraclexe\app\oracle\product\11.2.0\server\bin\sqlplus hr/hr@xe @schema_list.sql
set NLS_LANG=.AL32UTF8
FOR /F "tokens=1" %%G IN (schema_list.txt) DO D:\oraclexe\app\oracle\product\11.2.0\server\bin\sqlplus %%G/%%G@XE @script_with_unicode_data.sql %%G