| Leo |
Posted: Jun 05, 2007 03:01:37 PM |
Total Post: 2
Joined: Jun, 2007
|
I am trying to create a PL/SQL package body on a 10g Oracle database and I get the following message:
Warning: Package Body created with compilation errors.
When I type "Show errors" at the SQL*PLus, I get "No Errors".
MY question is: why Show errors doesn't show the compilation errors and how can I get it to work, or if there is another way of finding out what these errors are so I can fix them.
Your response is greatly appreciated. I look forward to hearing from somebody, hopefully.
Thanks,
Leo |
|
|
 rajanikiran |
| Posted: Jun 06, 2007 09:51:23 AM |  |
|
Total Post: 4
Joined: Nov, 2006
|
hi,
Pl. try with this query.
select * from user_errors;
Thanks,
Kiran.
|
|
|
|
|
| KS |
| Posted: Jun 06, 2007 11:15:59 AM | |
|
Total Post: 65
Joined: Nov, 2006
|
i got this error when i was creating a procedure..
Just go thro ur procedure once, there may be a small syntatical error,
if u correct it then u will not get the warning.
-sri
|
|
|
|
|
| jolly |
| Posted: Jun 07, 2007 12:11:57 AM | |
|
Total Post: 8
Joined: Apr, 2007
|
U can try this to look for the errors at the end of ur package u must have mentioned.......
end package_name;
/
SHOW ERRORS;
you can try this and see whether u are able to see the errors or not.
|
|
|
|
|
| Leo |
| Posted: Jun 08, 2007 12:59:43 PM | |
|
Total Post: 2
Joined: Jun, 2007
|
Guys,
Thank you so much for your replys. Non of your suggestions worked. As a matter of fact I had tried them all already. I was able to see the errors using dba_errors table.
Thanks again for your time.
Leo
|
|
|
|
|
| KS |
| Posted: Jun 14, 2007 11:22:48 AM | |
|
Total Post: 65
Joined: Nov, 2006
|
Hi all,
I saw this in some other forum,
I find it useful, so i'm posting it here.
We can use the following to view all the errors, raised in the PL/SQL SP.
SQL>ALTER SESSION SET plsql_warnings = 'enable:all';
Session altered.
SQL>CREATE PROCEDURE p AS
2 BEGIN
3 FOR i IN 3 .. 1 LOOP
4 DBMS_OUTPUT.Put_Line(i);
5 END LOOP;
6 END;
7 /
SP2-0804: Procedure created with compilation warnings
SQL>show error
Errors for PROCEDURE P:
LINE/COL ERROR
-------- -----------------------------------------------------------------3/4 PLW-06002: Unreachable code4/7 PLW-06002: Unreachable code
For complete information :
http://forums.oracle.com/forums/thread.jspa?threadID=519997&start=15&tstart=0
Regards ,
Sri.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
