that will merely tell you the object exists and that it is either valid (cleanly compiled) or invalid (needs recompilation)
--- Sinard Xing <[EMAIL PROTECTED]> wrote: > Hi, > > You can do > > Select object_name, object_type, status > from dba_objects > where object_type like '%PACK%' or > object_type like '%PROCE%' > order by 2,1; > > > > Sinardy > > > -----Original Message----- > [EMAIL PROTECTED] > Sent: 22 January 2002 15:10 > To: Multiple recipients of list ORACLE-L > > > > Can anyone give me a good example on how this works? > Thanks in advance > > Roland > > > > > > > > > Connor McDonald <[EMAIL PROTECTED]>@fatcity.com den 2001-10-25 01:45 > PST > > Sänd svar till [EMAIL PROTECTED] > > Sänt av: [EMAIL PROTECTED] > > > Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Kopia: > > I would say that the best way is in its coding > typically by adding calls to dbms_application_info - > which is great way of tying SQL to its owning PL/SQL > as well. > > You might be lucky to catch it in sql_address in > v$session (depending on what its actually doing at the > time). Similarly, you could possibly glean some info > from V$SQL via USERS_EXECUTING > > You could always try modify the proc which would > probably hang on library cache pin or similar - hardly > a recommended way of course :-) > > hth > connor > > --- Doug C <[EMAIL PROTECTED]> wrote: > How can I tell > if a stored procedure or package is > > in the middle of execution? > > (for lack of doing what it does).. I've heard of > > parse locks, is that a way? > > > > Thanks, > > D > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Doug C > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California -- Public Internet > > access / Mailing Lists > > > -------------------------------------------------------------------- > > 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). > > ===== > Connor McDonald > http://www.oracledba.co.uk (mirrored at > http://www.oradba.freeserve.co.uk) > > "Some days you're the pigeon, some days you're the statue" > > ____________________________________________________________ > Nokia Game is on again. > Go to http://uk.yahoo.com/nokiagame/ and join the new > all media adventure before November 3rd. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?Connor=20McDonald?= > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > -------------------------------------------------------------------- > 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.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > -------------------------------------------------------------------- > 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.com > -- > Author: Sinard Xing > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > -------------------------------------------------------------------- > 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). __________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
