PLS-00553: character set name is not recognized
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: PLS-00553: character set name is not recognized

  1. #1
    Join Date
    Jan 2006
    Posts
    4

    PLS-00553: character set name is not recognized

    Hi all,

    The following error occured when I executed the procedure through sqlplus:

    SQL> exec scp_mig_people
    ERROR:
    ORA-06550: line 1, column 29:
    PLS-00553: character set name is not recognized
    ORA-06550: line 0, column 0:
    PL/SQL: Compilation unit analysis terminated

    Any idea? But anyway it is excuted fine.

    Thanks!
    Praveena

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    what is the version and OS?
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Oct 2011
    Posts
    2

    Re:PLS-00553

    I have searched for a resolution to this problem for several months now since upgrading to PL/SQL Developer V9.0.0.1601 running on Windows XP.

    I have tried ALL suggestions I can find for setting the NLS_LANG variable under HKEY_LOCAL_MACHINE / SOFTWARE / Oracle in the registry. I have also set NLS_LANG as an Environment Variable. I have even removed the key from the registry. Up to this point NO suggested solution I've tried has EVER worked. I have simply learned to live with the interruption of this constant popup when performing almost any action in PL/SQL Developer. It doesn't matter whether I match the value in NLS_CHARACTERSET or not.

    Does anyone have a solution that actually works? If so provide details, please. Thanks.

  4. #4
    Join Date
    Jul 2006
    Posts
    195
    Does any procedure work? Post the code to the procedure

  5. #5
    Join Date
    Oct 2011
    Posts
    2

    PLS-00553: character set name is not recognized

    As far as I can tell PL/SQL Developer still functions in my environment.

    I can't say for sure what if anything is not working properly. However, a simple query:
    select * from some_table

    generates a popup with the message(s): (can't paste the image here)
    *****
    ORA-06550: line 2, column 36:
    PLS-00553: character set name is not recognized
    ORA-06550: line 0, column 0:
    PL/SQL: Compilation unit analysis terminated
    *****
    I click OK the popup goes away. I try something like 'fetch last page', the popup reappears. And so on. I am able to use PL/SQL Developer, it is just intolerably slow due to these constantly recurring and annoying popups.

    One thing that does not work when I try to do a query such as:

    select * from some_table t where t. --Normally I expect a list of column names to appear here, but the only thing I get is the popup

    So I've actually resorted to constructing the query in notepad and then
    pasting into the query windows:

    select * from some_table t order by t.fiscal_date

    Other than that I can successfully run queries, compile procedures, etc.

    Ugh!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width