Home » SQL & PL/SQL » SQL & PL/SQL » Urgent : Error Message problem
Urgent : Error Message problem [message #366066] Wed, 25 October 2000 19:00 Go to next message
Suresh.N
Messages: 41
Registered: March 2000
Member
Hi All!

I have some problem in my database.

If I tried to create a Procedure with error or any PL/SQL block with error.
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..

I ran all the three
catproc.sqlpupbld.sql and v8pup.sql in my db.

Still I have the problem.

How to solve this ?

What i did was ..

I tried to create one proc with error.

SQL> create or replace procedure p1
2 is
3 begin
4 select * from notable;
5 end;
6 /

Warning: Procedure created with compilation errors.

SQL> show err
Errors for PROCEDURE P1:

LINE/COL ERROR
-------- -----------------------------------------------------------------
4/2 PL/SQL: SQL Statement ignored
4/16 PLS-00201: Message 201 not found; No message file for
product=plsql, facility=PCM

The Same thing I tried with another database which I have..

SQL> create or replace procedure p1
2 is
3 begin
4 select * from notable;
5 end;
6 /

Warning: Procedure created with compilation errors.

SQL> show err
Errors for PROCEDURE P1:

LINE/COL ERROR
-------- -----------------------------------------------------------------
4/1 PL/SQL: SQL Statement ignored
4/15 PLS-00201: identifier 'NOTABLE' must be declared

Previously I was able to see all the error messages by using SHOW ERRor

Now I am not able to see. It is not displaying the error messages.

Give me a suggestion...

Thanks and Regards
Suresh.N
Re: Urgent : Error Message problem [message #366073 is a reply to message #366066] Wed, 01 November 2000 06:52 Go to previous message
Just Me
Messages: 10
Registered: November 2000
Junior Member
Check if the user in this database has the following GRANTs (to give these GRANTS to the user you have to connect as system/manager):
GRANT RESOURCE TO ----USER----
GRANT CONNECT TO ----USER----
Previous Topic: Insert inside PL/SQL Procedure
Next Topic: SOMEBODY ASSIST!!!!! - UTL_FILE package functions fails
Goto Forum:
  


Current Time: Fri Mar 29 02:58:01 CDT 2024