Re: How to get more info

type

show error

or

show errors

then the errors of the last object compiled will be shown (in sqlplus) to be more precise type

show errors <object_type> <object_name>
e.g.
show errors package body DUMMY
or
show errors procedure TEST

Kurt

"Peasant" <uhwotDELETETHIS_at_coldmail.com> wrote in message news:jn3p9tk9d8dlicc3hftcib020o14onhv46_at_4ax.com...
> How can I get more information back from the server regarding
> procedure compilation errors / warnings ?
>
> Scenario :
>
> CREATE OR REPLACE PROCEDURE "MJF"."tstprc" (vstuff in varchar2)
> is
> begin
> select fld1 from tbl3 where fld4=vstuff;
> end;
>
> If this is run through SQLPlus Worksheet, I simply get
>
> "Warning: Procedure created with compilation errors."
>
>
> That's a real swell response that ! Akin to "A hardware or software
> error has occured". Can I get Oracle to output more information
> regarding such problems ?
>
> If I (try) create this procedure with DBA Studio, its status stays
> "Invalid" (but the Errors windows is empty.)
>
>
> Peasant
Received on Wed Feb 28 2001 - 00:50:42 CST