| connect database from 7i to 9i [message #194332] |
Thu, 21 September 2006 09:43  |
703009827
Messages: 10
Registered: June 2006
|
Junior Member |
|
|
Hi,
My Oracle 7i database NLS_LANG=AMERICAN_AMERICA.US7ASCII
and oracle 9i database NLS_LANG=AMERICAN_AMERICA.UTF8
I was trying to connect from 7i database to 9i I am getting
the below error.
Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-06550: line 1, column 40:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated
But its connecting to 9i database.
I want to connect 9i database from 7i database and want to insert/update a row in 9i db.
I just want know is there any effect in 9i db if i insert the row.
Please let us know how to ignore the above error messages.
I can't change the character set any of the dbs bconz its prod dbs.
Help me on this issue.
Thanks,
Siva
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
