This discussion is archived
5 Replies Latest reply: Jul 4, 2012 7:43 AM by Srini Chavali-Oracle RSS

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

user4409597 Newbie
Currently Being Moderated
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
  • 1. Re: ORA-06553: PLS-553: character set name is not recognized
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    user4409597 wrote:
    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
    Pl post details of OS and database versions.
    This happens when I try to get the tables in clients like "Oracle SQL Developer" or "SQL Tools".
    Did this ever work before without errors ? If so, what has changed since then ?
    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.
    Pl identify exactly how you "set NLS_CHARACTERSET = AL32UTF8" and how you figured out "lost of special characters"

    HTH
    Srini
    >
    What can I do?

    Thanks in advance
  • 2. Re: ORA-06553: PLS-553: character set name is not recognized
    user4409597 Newbie
    Currently Being Moderated
    Srini Chavali wrote:
    user4409597 wrote:
    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
    Pl post details of OS and database versions.
    open SuSE 11.3 x64 and Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
    >
    This happens when I try to get the tables in clients like "Oracle SQL Developer" or "SQL Tools".
    Did this ever work before without errors ? If so, what has changed since then ?
    I made two copies from a schema. I did not make any other change
    >
    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.
    Pl identify exactly how you "set NLS_CHARACTERSET = AL32UTF8" and how you figured out "lost of special characters"
    Because when I select rows from a table, I get a strange symbol (like a rectangle) instead of the special character

    Sorry by duplicating this post, but I need a solution urgently

    Thanks in advance
  • 3. Re: ORA-06553: PLS-553: character set name is not recognized
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Pl provide details of

    Did this ever work before without errors ? If so, what has changed since then ?
    I made two copies from a schema. I did not make any other change

    Pl identify exactly how you "set NLS_CHARACTERSET = AL32UTF8"

    For all urgent requests, pl create an SR with Support - forums should not be used a a substitute for Support

    HTH
    Srini
  • 4. Re: ORA-06553: PLS-553: character set name is not recognized
    user4409597 Newbie
    Currently Being Moderated
    Srini Chavali wrote:
    Pl provide details of

    Did this ever work before without errors ? If so, what has changed since then ?
    I made two copies from a schema. I did not make any other change
    I export a schema and then I import it twice in the same database. I used exp and imp tools
    >
    Pl identify exactly how you "set NLS_CHARACTERSET = AL32UTF8"
    alter database character set AL32UTF8;
    shutdown immediate;
    startup;
    >
    For all urgent requests, pl create an SR with Support - forums should not be used a a substitute for Support
    I am new to these things. Where can I create a SR with Support?
    >
    HTH
    Srini
  • 5. Re: ORA-06553: PLS-553: character set name is not recognized
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    user4409597 wrote:
    Srini Chavali wrote:
    Pl provide details of

    Did this ever work before without errors ? If so, what has changed since then ?
    I made two copies from a schema. I did not make any other change
    I export a schema and then I import it twice in the same database. I used exp and imp tools
    Pl post the exact commands used.

    >>
    Pl identify exactly how you "set NLS_CHARACTERSET = AL32UTF8"
    alter database character set AL32UTF8;
    shutdown immediate;
    startup;
    You cannot use ALTER command to change the characterset of a database - this will corrupt the database beyond repair - I hope you have a backup of this database from before the ALTER command was issued (or that this is a play or throwaway database)

    http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch11charsetmig.htm#g1011430

    Changing the characterset is not a trivial exercise and should be done with a lot of caution.

    What you have posted so far does not indicate an issue with the characterset, hence my requests for detailed information.

    >>
    For all urgent requests, pl create an SR with Support - forums should not be used a a substitute for Support
    I am new to these things. Where can I create a SR with Support?
    HTH
    Srini
    If you have purchased a support contract with Oracle, log in to https://support.oracle.com to create a service request.

    HTH
    Srini

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points