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

Home -> Community -> Usenet -> c.d.o.server -> Re: Procedure compilation errors

Re: Procedure compilation errors

From: Tomm Carr <carr%tw_at_edwards.af.mil>
Date: 1997/08/19
Message-ID: <33FA4874.3FCD@edwards.af.mil>#1/1

Dinar Dhond wrote:
>
> I have created a stored procedure in sqlplus, but I keep getting an
> error Warning: Procedure created with compilation errors.
>
> How can I display the compilaton errors?

Use the sqlplus command 'show errors'. AAMOF, this is so handy, I end all my sp code scripts with

 ...
 end;
 /
 show errors
 /

-- 
Tomm Carr
---- ----
Hunting for a job is like hunting for an elephant.
If you're not *very* careful, you might find one!
Received on Tue Aug 19 1997 - 00:00:00 CDT

Original text of this message

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