Janet,
1. Did you try to compile the SP in your session before doing the show errors? It will only show errors to you if you did the compile prior to doing show errors. 2. One of the resons this could occur if there are stored objects like other packages, functions and procedure being referred to in your procedure and if they are invalid. If there are a number of invalid objects then this problem may occur..One way to verify this is to remove the dbms lines and try recompiling the package and see if it compiles.. Viral >From: "BALA,PRAKASH (Non-HP-USA,ex1)" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: couple of questions ??? >Date: Fri, 06 Sep 2002 11:58:29 -0800 > >Janet, > >The last place where I worked, we had to split a big package into smaller >ones since we hit a # of lines limit (undocumented!). > >Prakash > >-----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). _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viral Desai 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).
