| Urgent : Error Message problem [message #369858] |
Wed, 25 October 2000 18:59 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
