Re: Help: how to compile/debug a stored package

From: <joshis_at_detroitedison.com>
Date: 1996/03/06
Message-ID: <4hkeq6$ofm_at_news.deco.com>#1/1


The sql*plus command 'Show Errors' describes all errors encountered in last compile. The 'Oracle7 Application Developer's Guide' talks in detail about stored packages,procedures & functions.

Sacoolcat_at_citynet.net wrote:
>mcchan_at_cs.cityu.edu.hk (¤@ ¶§ «ü ) wrote:
>
>>Hi,
 

>> I am new to Oracle. When I compiled a stored package, I got the message
>> "Warning: Package created with compilation errors.
>> Warning: Package Body created with compilation errors."
 

>> I want to ask how can I know what's wrong in compilation. Besides
>>"PL/SQL User's Guide and Reference", where can I find information
>>talking about stored package?
 

>> Thanks!
>
>
>Try:
>
>SELECT * from user_errors;
>

nat Received on Wed Mar 06 1996 - 00:00:00 CET

Original text of this message