character set not compatible
I have created a new database version 9.2 with characterset AL32UTF8 and national characterset AL16UTF8.
The old database which I try to import from is using characterset US7ASCII instead.
This will caused an error shown below when I try to connect to a function or procedure using a db link.
ERROR:
ORA-06550: line 1, column 29:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated
How do i solve this?? :confused: