Stored Procedures/Functions
Dear Gurus How would one monitor when and who may be executing a stored procedure/package etc at any one point in time. Similar to table locks although thats more straightforward to monitor. Pls advise Thanks in Advance IMPORTANT: This e-mail (including all attachments) is confidential and may be privileged. It may be read, copied and used only by the intended recipients, and must not be re-transmitted in any form without our consent. If you have received it in error, please contact us immediately by return e-mail. Please then delete it and do not disclose its contents to any other person. Security and reliability of email is not guaranteed. Communications should be verified from a mailed or faxed copy. All emails to anyone @vitol.com are communications to the firm and are not private or confidential to any named individual. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Easaw T Mathew 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).
RE: Stored procedures, functions and packages
You can use describe in SQL*Plus to look at the arguments (parameters) only. HTH - Bhat -Original Message- From: Carlos Porras [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 7:01 AM To: Multiple recipients of list ORACLE-L Subject:Stored procedures, functions and packages Hi all, Gurus. Is there a view or synonym that stores the declaration part of procedures, functions and/or packages?. That is, something like SYS.argument$, user_arguments or all_arguments (useful for example to access the arguments of stored procedures and functions in an easy, structured way), but in this case of course only related to variables, types, constants, etc. (that is, the declaration part within the stored procedures, functions and packages)? Thanks a lot. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carlos Porras 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).
Stored procedures, functions and packages
Hi all, Gurus. Is there a view or synonym that stores the declaration part of procedures, functions and/or packages?. That is, something like SYS.argument$, user_arguments or all_arguments (useful for example to access the arguments of stored procedures and functions in an easy, structured way), but in this case of course only related to variables, types, constants, etc. (that is, the declaration part within the stored procedures, functions and packages)? Thanks a lot. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carlos Porras 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).