This content has been marked as final. Show 9 replies
If a shutdown/restart of the instance,does not fix the issue, you may have a character set mixup according to Metalink note:
Subject: PLS-553 when calling or compiling pl/sql objects
Doc ID: Note:286964.1 Type: BULLETIN
Last Revision Date: 10-JUL-2006 Status: PUBLISHED
Did you change the database character set recently ?
I am afraid most people on this forum do not speak French. You will have to describe your situation and details of the steps taken in English.
Also, if you have a valid Support contract, you should contact Oracle Support. They have people speaking French and they can do a proper analysis of your system.
You can not update your nls_language directly, but you can use below command, to change your language to what you want.
update sys.props$ set value$='AL32UTF8' WHERE NAME='NLS_CHARACTERSET';
update sys.props$ set value$='AL32UTF8' WHERE NAME='NLS_NCHAR_CHARACTERSET';
Also it's possible to select your charset from AL32UTF8 to anything you want, have a look to this article:"Choosing Charset": http://download.oracle.com/docs/cd/E11882_01/server.112/e10729/ch2charset.htm#i1007681.
Edited by: S. Wolicki, Oracle on Dec 8, 2010 3:37 AM
Never use the above advice.