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
