Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_APPLICATION_INFO, 3 of 7
This procedure sets the name of the current action within the current module. The action name should be descriptive text about the current action being performed. You should probably set the action name before the start of every transaction.
DBMS_APPLICATION_INFO.SET_ACTION ( action_name IN VARCHAR2);
Set the transaction name to NULL
after the transaction completes, so that subsequent transactions are logged correctly. If you do not set the transaction name to NULL
, then subsequent transactions may be logged with the previous transaction's name.
The following is an example of a transaction that uses the registration procedure:
CREATE OR REPLACE PROCEDURE bal_tran (amt IN NUMBER(7,2)) AS BEGIN -- balance transfer transaction DBMS_APPLICATION_INFO.SET_ACTION( action_name => 'transfer from chk to sav'); UPDATE chk SET bal = bal + :amt WHERE acct# = :acct; UPDATE sav SET bal = bal - :amt WHERE acct# = :acct; COMMIT; DBMS_APPLICATION_INFO.SET_ACTION(null); END;
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|