Procedure not compiled successfully. But shows no error [message #334653] |
Thu, 17 July 2008 10:22  |
shrinika
Messages: 306 Registered: April 2008
|
Senior Member |
|
|
Hello all,
I am creating the package and it is not compiled successfully. But it is showing no errors. Can any one help me on this?
reports> set scan off
reports> start d:/govind/reports/reports.sql
Package created.
Warning: Package Body created with compilation errors.
reports> show err
No errors.
Here is the DB version i am using
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for Linux: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
|
|
|
|
|
|
|
|
Re: Procedure not compiled successfully. But shows no error [message #334721 is a reply to message #334658] |
Thu, 17 July 2008 14:55   |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
anacedent wrote on Thu, 17 July 2008 17:43 | SQL*Plus usually will display the error via
SQL> SHOW ERROR
but sometimes it does not.
I have never been able to discern any pattern & it really, really does not matter.
If SHOW ERROR provides the details, then fine.
If not, then use SELECT...
It just a few more keystrokes.
You should be glad that SHOW ERROR works in most cases.
|
As far as I experienced, show error will only work if the creation of the object was the very last thing you did before typing SHOW ERROR.
Thus, directly after the /
In scripts it might be a good idea to add SHOW ERROR after each step.
|
|
|
Re: Procedure not compiled successfully. But shows no error [message #334734 is a reply to message #334653] |
Thu, 17 July 2008 15:35  |
 |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
govindts | Package created.
Warning: Package Body created with compilation errors.
reports> show err
No errors.
|
Just wondering, could you try it once again and - instead of "show errors" typeSQL> SHOW ERRORS package_body_name What's the result? No errors again, or ...?
|
|
|