RE: couple of questions ???

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Fri, 06 Sep 2002 12:08:26 -0800
Message-ID: <F001.004CA431.20020906120826@fatcity.com>

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: 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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

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:08:26 CDT