Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Generic code for looking at pl/sql stored procedure arguments

Re: Generic code for looking at pl/sql stored procedure arguments

From: Jeremy <newspostings_at_hazelweb.co.uk>
Date: Tue, 22 Mar 2005 08:00:01 -0000
Message-ID: <MPG.1ca9e0dbf6287bd8989de5@news.individual.net>


In article <1111440359.884485_at_yasure>, DA Morgan says...
>
> What do you mean by generic and extract when? It matters.
>

Generic as in a simple "utility" call to dump name/value pairs for the arguments so that this can be added to an "invocation record". Extract I guess I mean "obtain" and this woul dbe required on every invocation.

> If you are talking about real-time, in production, no. Otherwise
> one can use DBMS_DEBUG or DBMS_APPLICATION_INFO without impacting
> resources. In 10g look too at DBMS_MONITOR.
>

Yes it would have been real-time, production.

-- 

jeremy
Received on Tue Mar 22 2005 - 02:00:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US