Home » SQL & PL/SQL » SQL & PL/SQL » Procedure not compiled successfully. But shows no error (Oracle10g)
Procedure not compiled successfully. But shows no error [message #334653] Thu, 17 July 2008 10:22 Go to next message
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 #334655 is a reply to message #334653] Thu, 17 July 2008 10:29 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
run the following SQL:
select view_name from dba_views where view_name like '%ERROR%'

Then get creative.
Re: Procedure not compiled successfully. But shows no error [message #334657 is a reply to message #334655] Thu, 17 July 2008 10:40 Go to previous messageGo to next message
shrinika
Messages: 306
Registered: April 2008
Senior Member
Thanks and now i got the point. But before 10g, i used see the error message when i type show error. Is this something changed in 10g?? thanks
Re: Procedure not compiled successfully. But shows no error [message #334658 is a reply to message #334653] Thu, 17 July 2008 10:43 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
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.
Re: Procedure not compiled successfully. But shows no error [message #334665 is a reply to message #334658] Thu, 17 July 2008 10:55 Go to previous messageGo to next message
shrinika
Messages: 306
Registered: April 2008
Senior Member
Thank you. Appreciate your reply.
Re: Procedure not compiled successfully. But shows no error [message #334666 is a reply to message #334653] Thu, 17 July 2008 10:59 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be neighborly if you would "close the loop" by posting how you solved your problem.
Re: Procedure not compiled successfully. But shows no error [message #334721 is a reply to message #334658] Thu, 17 July 2008 14:55 Go to previous messageGo to next message
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 Go to previous message
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" type
SQL> SHOW ERRORS package_body_name
What's the result? No errors again, or ...?
Previous Topic: ORA-00054: resource busy and acquire with NOWAIT specified indexe creation
Next Topic: Deferred Constraint Without Dropping Existing Constraint
Goto Forum:
  


Current Time: Thu Feb 13 19:56:16 CST 2025