5 Replies Latest reply: Jul 4, 2012 9:43 AM by Srini Chavali-Oracle RSS

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

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