Home » RDBMS Server » Server Administration » About Pl/SqL error messages
About Pl/SqL error messages [message #369765] Thu, 05 October 2000 18:07 Go to next message
Suresh.N
Messages: 41
Registered: March 2000
Member
Hi!

I have some problem in my database.

If I tried to create a Procedure or any PL/SQL
block if there is any error I couldn't see the error messages.

It is giving like below

ERROR at line 1:
ORA-06540: PL/SQL: compilation error
ORA-06553: PLS-906: Message 906 not found; No message file for product=plsql, facility=PCM

For I try the same PL/SQL in Some other database it is giving the error messages..

I think Some problem in DBMS Packages...
I think It may be DBMS_STANDARD package problem..

How to solve this ?

Give me a suggestion...

Thanks in Advance..

Thanks and Regards
Suresh.N

Report message to a moderator

Re: About Pl/SqL error messages [message #369776 is a reply to message #369765] Tue, 10 October 2000 13:08 Go to previous messageGo to next message
Bobby
Messages: 32
Registered: August 2000
Member
Hi Suresh,

Try locating the error by typing "oerr ora 06540(error number)" at the unix command prompt.

Bob

Report message to a moderator

Re: About Pl/SqL error messages [message #369777 is a reply to message #369765] Tue, 10 October 2000 13:09 Go to previous messageGo to next message
Bobby
Messages: 32
Registered: August 2000
Member
Hi Suresh,

Try locating the error by typing "oerr ora 06540(error number)" at the unix command prompt.

Bob

Report message to a moderator

Re: About Pl/SqL error messages [message #369778 is a reply to message #369765] Tue, 10 October 2000 13:09 Go to previous messageGo to next message
Bobby
Messages: 32
Registered: August 2000
Member
Hi Suresh,

Try locating the error by typing "oerr ora 06540(error number)" at the unix command prompt.

Bob

Report message to a moderator

Re: About Pl/SqL error messages [message #369779 is a reply to message #369765] Tue, 10 October 2000 13:52 Go to previous message
Suresh.N
Messages: 41
Registered: March 2000
Member
Hi !

Thanks for Reply
Normally if any error comes, "show error" disply the error problem . For me it doesn't work.

Thanks and Regards
Suresh

Report message to a moderator

Previous Topic: Urgent ...... ORA-01002. Fetch Out of sequence
Next Topic: Linking Database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 00:39:40 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.