RE: RE: SHOW ERRORS not working

Nope, in fact this is a good example of my failure to "read the whole question before replying". I thought Dave said no output was showing ... but he really said no errors were showing after the response that there were errors. My bad. I blame the fact it's Monday :-)

I think the other suggests on user_errors etc. are on the right track.

Ciao
Fuzzy
:-)

> -----Original Message-----
> From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On Behalf Of
> rgaffuri_at_cox.net
> Sent: Monday, July 21, 2003 17:44
> To: Multiple recipients of list ORACLE-L
> Subject: Re: RE: SHOW ERRORS not working
>
>
> 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).
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.net

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