Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Package function problems

Re: Package function problems

From: Walter Dnes <waltdnes_at_interlog.com>
Date: Mon, 08 Mar 1999 05:10:30 GMT
Message-ID: <36ed5747.173056589@news.interlog.com>


On Sun, 07 Mar 1999 19:40:11 GMT, tkyte_at_us.oracle.com (Thomas Kyte) wrote:

>the package is invalid in the database -- it didn't compile successfully.
>
>In sqlplus issue:
>
>SQL> show errors package body WD;

  Thanks. I'm new to packages. While I was aware of "show errors", I wasn't aware of the "show errors package body ..." variant. Once I knew that I had an error in that function, I was able to track it down.

--
Walter Dnes <waltdnes_at_interlog.com> procmail spamfilter http://www.interlog.com/~waltdnes/spamdunk/spamdunk.htm Why a fiscal conservative opposes Toronto 2008 OWE-lympics http://www.interlog.com/~waltdnes/owe-lympics/owe-lympics.htm Received on Sun Mar 07 1999 - 23:10:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US