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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> [EMAIL PROTECTED]
> 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" <[EMAIL PROTECTED]>
> > Date: 2003/07/21 Mon PM 12:24:24 EDT
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > 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: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
> > >
> > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).