Re: SHOW ERRORS not working
Hi! Yep, show user for example doesn't even generate any sqlnet traffic to server. The username is retrieved by sqlplus once during logon using "select user from dual" query. One small detail is that when connecting as sysdba, no "select user from dual" query is executed during logon, because you'll become sys anyway... Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 22, 2003 6:04 PM > SHOW PARAMETER performs a 'FIXED TABLE FULL' scan of x$ksppi and x$ksppcv. Exactly what I would expect. > SHOW USER did not show up in the trace file, which tells me it is internal code path. SHOW ALL did the same. I think that the difference is that PARAMETERs are database level information, where USER and ALL are related to sql*plus. > > Pete Finnigan wrote: > > > > Hi Dave > > > > I have had the same issue before but i don't remember the answer but I > > think i found it with either trace or SQL*Net trace. > > > > I think show is a keyword implemented in SQL*Plus that simply translates > > into some SQL. Set trace on your session and on your users session and > > use tkprof with SYS = yes to collect all SQL including ddl and see if a > > difference is shown between your session and his, you in theory should > > have the same SQL as him but it could indicate where the difference > > lies. Or an alternative is to use SQL*Net trace at SUPPORT level and you > > should see the SQL used in the packet contents. > > > > hope this helps > > > > kind regards > > > > Pete > > -- > > Pete Finnigan > > email:[EMAIL PROTECTED] > > Web site: http://www.petefinnigan.com - Oracle security audit specialists > > Book:Oracle security step-by-step Guide - see http://store.sans.org for details. > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Pete Finnigan > > 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: Tanel Poder 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).
Re: SHOW ERRORS not working
SHOW PARAMETER performs a 'FIXED TABLE FULL' scan of x$ksppi and x$ksppcv. Exactly what I would expect. SHOW USER did not show up in the trace file, which tells me it is internal code path. SHOW ALL did the same. I think that the difference is that PARAMETERs are database level information, where USER and ALL are related to sql*plus. Pete Finnigan wrote: > > Hi Dave > > I have had the same issue before but i don't remember the answer but I > think i found it with either trace or SQL*Net trace. > > I think show is a keyword implemented in SQL*Plus that simply translates > into some SQL. Set trace on your session and on your users session and > use tkprof with SYS = yes to collect all SQL including ddl and see if a > difference is shown between your session and his, you in theory should > have the same SQL as him but it could indicate where the difference > lies. Or an alternative is to use SQL*Net trace at SUPPORT level and you > should see the SQL used in the packet contents. > > hope this helps > > kind regards > > Pete > -- > Pete Finnigan > email:[EMAIL PROTECTED] > Web site: http://www.petefinnigan.com - Oracle security audit specialists > Book:Oracle security step-by-step Guide - see http://store.sans.org for details. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Pete Finnigan > 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).begin:vcard n:Fink;Daniel tel;cell:303.808.3282 tel;work:303.272.3225 x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;-4832 fn:Daniel Fink end:vcard
Re: SHOW ERRORS not working
Hi Dave I have had the same issue before but i don't remember the answer but I think i found it with either trace or SQL*Net trace. I think show is a keyword implemented in SQL*Plus that simply translates into some SQL. Set trace on your session and on your users session and use tkprof with SYS = yes to collect all SQL including ddl and see if a difference is shown between your session and his, you in theory should have the same SQL as him but it could indicate where the difference lies. Or an alternative is to use SQL*Net trace at SUPPORT level and you should see the SQL used in the packet contents. hope this helps kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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).
Re: SHOW ERRORS not working
I don't think SHOW is a function that you will find in any of the Oracle db creation scripts. It is most likely part of the sql*plus program. The keyword SHOW can be used for a lot of things (USER and PARAMETER come to mind). Obviously, it reads some data structures, but I am sure it is not a stored proc. [EMAIL PROTECTED] wrote: > > 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.bsqbegin:vcard n:Fink;Daniel tel;cell:303.808.3282 tel;work:303.272.3225 x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;-4832 fn:Daniel Fink end:vcard
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: [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).
RE: SHOW ERRORS not working
Have you tried 'show errors procedure blabla'? Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson 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).
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).
Re: SHOW ERRORS not working
ask him to try "select * from user_errors" if that works ? -ak - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 21, 2003 8:44 AM > 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: AK 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).
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 >>> [EMAIL PROTECTED] 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: [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: Ron Rogers 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).
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).
RE: SHOW ERRORS not working
Not sure how SHOW ERRORS is implemented in SQLPlus, but it may only be looking at USER_ERRORS intead of ALL_ERRORS. So if your developer is altering another schema's procedure (via the alter ANY procedure privilege) those errors will not show up in his USER_ERRORS. BTW, this is just my guess on this; haven't tried it out myself. -Original Message- Sent: Monday, July 21, 2003 11:45 AM To: Multiple recipients of list ORACLE-L 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: Rudy Zung 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).
RE: SHOW ERRORS not working
Not sure, what causes the problem. But, probably a workaround is to grant him rights to select from dba_errors. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Farnsworth, Dave Sent: Monday, July 21, 2003 10:45 AM To: Multiple recipients of list ORACLE-L 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: Igor Neyman 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).
RE: SHOW ERRORS not working
Title: RE: SHOW ERRORS not working select grant on all_errors ?? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, July 21, 2003 11:45 AM 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). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: SHOW ERRORS not working
Have him try "SHOW ERRORS PROCEDURE " Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, July 21, 2003 11:45 AM To: Multiple recipients of list ORACLE-L 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: Gogala, Mladen 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).