Janet, The Show Errors command is only good if you were to reload the package from disk. Maybe if you did an alter package compile. Since you did neither, this command does not help you.
Your other problem could be caused by the package being executed by someone while you were trying to compile it. IN this case, the package is locked until the execution is complete. Good Luck! Tom Mercadante Oracle Certified Professional -----Original Message----- Sent: Thursday, September 05, 2002 5:58 PM To: Multiple recipients of list ORACLE-L Hi all, I have couple of questions, 817 on NT. 1. There is an invalid SP, my collegue did a Show Errors in SQL Plus, it shows the error; but I did the same thing in my Sql Plus, I got "No errors". Is there any settings I need to change? 2. There is a valid SP, when I did a Alter procedure p_Name compile. It just hangs. It was compiling fine, now I added two lines (dbms_output stuff), and it just compiling forever. The code now has 7969 lines. Does that hit the limit? (I really doubt) Or are there any other reasons? Thanks, Janet __________________________________________________ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.com -- Author: BALA,PRAKASH (Non-HP-USA,ex1) INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
