RE: couple of questions ???

From: Viral Desai <viral303_at_hotmail.com>
Date: Fri, 06 Sep 2002 12:48:45 -0800
Message-ID: <F001.004CA529.20020906124845@fatcity.com>

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)" <prakash_bala_at_non.hp.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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: janetlinsy_at_yahoo.com
>
>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: 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.com
>--
>Author: BALA,PRAKASH (Non-HP-USA,ex1)
> INET: prakash_bala_at_non.hp.com
>
>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: 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).

---

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: viral303_at_hotmail.com

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: 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 Fri Sep 06 2002 - 15:48:45 CDT