you sure? Ive noticed this before. SHOW ERRORS is a function. Do you know where its created? you can find the code and then just craete the show errors function? might be in sql.bsq
>
> From: "Grant Allen" <grant_at_towersoft.co.uk>
> Date: 2003/07/21 Mon PM 12:24:24 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: RE: SHOW ERRORS not working
>
> This used to get me all the time. I'm pretty sure you need to issue
>
> SET SERVEROUTPUT ON;
>
> to see the output.
>
> Ciao
> Fuzzy
> :-)
>
>
> > -----Original Message-----
> > From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On Behalf Of
> > Farnsworth, Dave
> > Sent: Monday, July 21, 2003 16:45
> > To: Multiple recipients of list ORACLE-L
> > Subject: SHOW ERRORS not working
> >
> >
> > I have a developer that has ALTER ANY PROCEDURE rights. He
> > changes a procedure, then compiles it and it says there are
> > errors. But when he does a SHOW ERRORS in SQPlus, it shows
> > nothing. If I do the same thing I can see the errors from
> > the compiled procedure. I assume this is a permissions thing
> > but have not been able to figure this one out. Anyone have
> > any ideas on this?
> >
> > Thanks,
> >
> > Dave
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Farnsworth, Dave
> > INET: DFarnsworth_at_Ashleyfurniture.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > 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.net
> --
> Author: Grant Allen
> INET: grant_at_towersoft.co.uk
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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 Mon Jul 21 2003 - 10:45:00 CDT
