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??