Home » SQL & PL/SQL » SQL & PL/SQL » Re-Compiling package
Re-Compiling package [message #232913] Tue, 24 April 2007 00:57 Go to next message
kssarayu
Messages: 18
Registered: March 2007
Junior Member
SQL>alter package A.B compile specification;

Warning: Package altered with compilation errors.

SQL> show errors
No errors



However, when i compiled using TOAD, i got the reason for failure as

he following error has occurred:

PACKAGE A.B
On line: 73
PLS-00302: component 'CDE' must be declared

Can any one assist me on what is wrong with "show errors". Why i am not getting valid error message using sqlplus.
Thanks
sarayu
Re: Re-Compiling package [message #232918 is a reply to message #232913] Tue, 24 April 2007 01:19 Go to previous messageGo to next message
kssarayu
Messages: 18
Registered: March 2007
Junior Member
For to mention the version details:

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for Solaris: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production

Re: Re-Compiling package [message #232919 is a reply to message #232918] Tue, 24 April 2007 01:24 Go to previous messageGo to next message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi

alter compile does not allow a show errors.

so try with select * from user_errors;

regards
shanth

[Updated on: Tue, 24 April 2007 01:25]

Report message to a moderator

Re: Re-Compiling package [message #232936 is a reply to message #232913] Tue, 24 April 2007 02:41 Go to previous messageGo to next message
kssarayu
Messages: 18
Registered: March 2007
Junior Member
Thanks. I could see the errors now.
Re: Re-Compiling package [message #233091 is a reply to message #232936] Tue, 24 April 2007 11:07 Go to previous messageGo to next message
William Robertson
Messages: 1640
Registered: August 2003
Location: London, UK
Senior Member
Or use the extended SHOW ERRORS syntax:

SQL> CREATE OR REPLACE PACKAGE testpkg AS
  2  this_is_an error;
  3  END testpkg;
  4  /

Warning: Package created with compilation errors.

SQL> show errors
Errors for PACKAGE TESTPKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2/12     PL/SQL: Declaration ignored
2/12     PLS-00201: identifier 'ERROR' must be declared
SQL>
SQL> alter package testpkg compile specification;

Warning: Package altered with compilation errors.

SQL> show errors
No errors.
SQL> show errors package testpkg
Errors for PACKAGE TESTPKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2/12     PL/SQL: Declaration ignored
2/12     PLS-00201: identifier 'ERROR' must be declared
Re: Re-Compiling package [message #233109 is a reply to message #233091] Tue, 24 April 2007 14:34 Go to previous message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi William Robertson,

i was not aware of this thanks Razz

regards,
shanth
Previous Topic: DBMS_DATAPUMP.ADD_FILE : ORA-39001
Next Topic: insert or update
Goto Forum:
  


Current Time: Fri Dec 09 19:15:56 CST 2016

Total time taken to generate the page: 0.22201 seconds