Oracle-L: RE: show errors doesn't show anything ???

From: Ron Thomas <rthomas_at_hypercom.com>
Date: Thu, 06 Mar 2003 13:19:09 -0800
Message-ID: <F001.005627DF.20030306131909@fatcity.com>

What this is trying to tell you is that the package header compiled cleanly but the body did not.

Either

show errors package body prv_admin

alter package priv_admin compile body
show errors

Ron Thomas
Hypercom, Inc
rthomas_at_hypercom.com
Each new user of a new system uncovers a new class of bugs. -- Kernighan

                                                                                                                                                 
                      Rajendra.Jamadagn                                                                                                          
                      i_at_espn.com               To:       ORACLE-L_at_fatcity.com                                                                    
                      Sent by:                 cc:                                                                                               
                      root_at_fatcity.com         Subject:  RE: show errors doesn't show anything ???                                               
                                                                                                                                                 
                                                                                                                                                 
                      03/06/2003 12:38                                                                                                           
                      PM                                                                                                                         
                      Please respond to                                                                                                          
                      ORACLE-L

select *
from user_errors
where name = 'PRV_ADMIN'
/

Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !!

-----Original Message-----
Sent: Thursday, March 06, 2003 1:24 PM
To: Multiple recipients of list ORACLE-L

Hi,

I have 9i on Linux Red Hat 2.4.9. A package is invalid after compiling. I did a show errors but nothing shows. How do I see where the error is ??

SQL> alter package prv_admin compile;

Warning: Package altered with compilation errors.

SQL> show errors;
No errors.

Thank you in advance!

Janet

Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janet Linsy INET: janetlinsy_at_yahoo.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). (See attached file: ESPN_Disclaimer.txt)

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: rthomas_at_hypercom.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

application/octet-stream attachment: ESPN_Disclaimer.txt

Received on Thu Mar 06 2003 - 15:19:09 CST