PLS-00553: character set name is not recognized

[praveena]

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

[sambavan]

what is the version and OS?

[tgorton99]

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.

[BeefStu]

Does any procedure work? Post the code to the procedure

[tgorton99]

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!