Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
#database-key-features, #globalization-support
5 comments
4,773 views