[Tip] Connect with Oracle Forms 6i on Oracle XE 10G

[goper]

I had problems connecting with Oracle Xe Universal through Oracle Forms 6i due to NLS settings.

To resolve the problem, I changed database character to UTF8 and can connect and use my application.

Connect to SQLPlus as SYSDBA (eg System / Password SYSDBA) and perform the steps below:

Select all

SQLPLUS>shutdown immediate 
SQLPLUS>startup restrict 
SQLPLUS>ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8; 
SQLPLUS>shutdown immediate 
SQLPLUS>startup

Environment information:
* Oracle version: Oracle XE 10G Universal
* Operating system: Windows XP, NT

[goper]

Complementing: for accentuation, consider

Select all

CHARACTER SET INTERNAL_USE WE8ISO8859P1;

[dr_gori]

Thanks for the tip!!! :-O