Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: show errors doesn't show anything ???

Re: show errors doesn't show anything ???

From: <Rick_Cale_at_teamhealth.com>
Date: Thu, 06 Mar 2003 11:59:26 -0800
Message-ID: <F001.00562542.20030306115926@fatcity.com>

You can try select * from dba_errors where name='PRV_ADMIN';

Rick

                                                                                                                
                    Janet Linsy                                                                                 
                    <janetlinsy_at_ya       To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>    
                    hoo.com>             cc:                                                                    
                    Sent by:             Subject:     show errors doesn't show anything ???                     
                    root_at_fatcity.c                                                                              
                    om                                                                                          
                                                                                                                
                                                                                                                
                    03/06/2003                                                                                  
                    01:23 PM                                                                                    
                    Please respond                                                                              
                    to 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Rick_Cale_at_teamhealth.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).
Received on Thu Mar 06 2003 - 13:59:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US