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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: How extensively do you use dbms_application_info ?

RE: How extensively do you use dbms_application_info ?

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Tue, 26 Sep 2006 07:26:11 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF615ADF@MSXVS04.trivadis.com>


Ryan

> Would you use dbms_application_info for every single pl/sql
> procedure? Even ones that just run a single query?
>
> I was thinking about floating this idea at work. This is how I would
> do it.
> Module: PL/SQL Package and Functional Module(this would be an
> internal name)
> Action: Procedure, plus any values that would go into bind
> variables.

Personally I like to see it at least for the procedures that are callable from outside the package.

Since the size of the action is limited... you are restricted about the amount of information you can give to it.

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 26 2006 - 00:26:11 CDT

Original text of this message

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