Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-06553: PLS-553: character set name is not recognized

user4409597Jul 3 2012 — edited Jul 4 2012
I have been getting this error for a while:

ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-553: character set name is not recognized

This happens when I try to get the tables in clients like "Oracle SQL Developer" or "SQL Tools".

When I execute this sentence:
select *
from nls_database_parameters
where parameter like '%CHARACTERSET%'

I get:
NLS_NCHAR_CHARACTERSET=AL16UTF16
NLS_CHARACTERSET=WE8ISO8859P1

Changing the NLS_CHARACTERSET parameter is not an option because this causes lost of special characters like á, ñ, etc.
I tested this by setting the NLS_CHARACTERSET = AL32UTF8 and it was when I figure out the lost of special characters.

What can I do?

Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 1 2012
Added on Jul 3 2012
5 comments
5,044 views