Archive

Archive for February, 2015

Error accessing package DBMS_APPLICATION_INFO

February 4, 2015 Leave a comment

After migrating oracle database from 7.3.4.0 to Oracle 12c1, some old oracle 7.3.4 clients showed the errors below

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

When asking oracle support, of course, they said that it was not support and upgraded to latest clients.Luckly, I found that it was caused by the database character set. After I recreated the database with the default characeter set  WE8MSWIN1252. The problem was fixed.

Categories: ORA-XXX