-
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
-
what is the version and OS?
Thanx
Sam
Life is a journey, not a destination!
-
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.
-
Does any procedure work? Post the code to the procedure
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|