RE: couple of questions ???
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).
RE: couple of questions ???
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).
RE: couple of questions ???
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).
Re: couple of questions ???
Check for Remote DB Link and connection to that DB if any. Check for the LOCKS. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, September 05, 2002 02:58 PM > 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: Nikunj Gupta 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).
Re: couple of questions ???
Janet, Your recompile requires taking a lock on all referenced objects. ( A share lock I think. A definite answer requires RTFM ) I would guess that your recompile is waiting on a lock. Jared Janet Linsy <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 09/05/2002 02:58 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:couple of questions ??? 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: 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).
RE: Couple of questions
True, but it probably looks good on a resume! -Original Message- Dandekar Sent: Thursday, March 22, 2001 11:02 AM To: Multiple recipients of list ORACLE-L > Also for those who have Oracle certification how much database experience > (Oracle in particular) did you have before you obtained certification? > What do you recommend for experience before attempting certification? OCP and Good Oracle DBA are not one of the same things. There might be people who are both. But... OCP does not necessarily mean Good DBA Good DBA, without any exam oriented preparation would not pass OCP so easily. I have heard that ILT notes and STS tests are simplest things to become "Paper OCP" even if you donot have Oracle expertise! I am persuing OCP, Just because after completing it I can commandingly say that OCP is NOT a great achievement. -Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar 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: Kevin Kostyszyn 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).
Re: Couple of questions
> Also for those who have Oracle certification how much database experience > (Oracle in particular) did you have before you obtained certification? > What do you recommend for experience before attempting certification? OCP and Good Oracle DBA are not one of the same things. There might be people who are both. But... OCP does not necessarily mean Good DBA Good DBA, without any exam oriented preparation would not pass OCP so easily. I have heard that ILT notes and STS tests are simplest things to become "Paper OCP" even if you donot have Oracle expertise! I am persuing OCP, Just because after completing it I can commandingly say that OCP is NOT a great achievement. -Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar 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).
Re: Couple of questions
On Thu, 22 Mar 2001,Donald Bricker scribbled on the wall in glitter crayon: ->Is anyone running Oracle 8.1.6 on Solaris 8? Any problems? Anything to be aware of? yup, no problems so far. however this is not a large database nor mission critical. YMMV.;-) -- Bill Thater Certifieable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ I believe that a scientist looking at nonscientific problems is just as dumb as the next guy.-- Richard Feynman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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).