Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: SHOW ERRORS not working
Dave,
Is the procedure owner the developer? If there are errors then they
would show up in user_errors other wise the errors are owned by the
owner of the procedure. Check the grants on the different xxx_error
tables and grant accordingly.
Ron
>>> DFarnsworth_at_Ashleyfurniture.com 07/21/03 11:44AM >>>
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).Received on Mon Jul 21 2003 - 10:38:14 CDT
![]() |
![]() |