To register applications with the database, use the procedures in the DBMS_APPLICATION_INFO package.
DBMS_APPLICATION_INFO Package
Table 3 - 1 lists the procedures available in the DBMS_APPLICATION_INFO package.
Procedure
Description
Discussed
SET_MODULE
Sets the name of the module that is currently running.
SET_ACTION
Sets the name of the current action within the current module.
SET_CLIENT_INFO
Sets the client information field for the session.
READ_MODULE
Reads the values of the module and action fields for the current session.
READ_CLIENT_INFO
Reads the client information field for the current session.
Table 3 - 1. Procedures in the DBMS_APPLICATION_INFO Package
Privileges
Before using this package, you must run the DBMSUTL.SQL script to create the DBMS_APPLICATION_INFO package. For more information about Oracle supplied packages and executing stored procedures, see Oracle7 Server Application Developer's Guide.
Caution: Do not use procedures in the DBMS_APPLICATION_INFO package if you are using the Trusted Oracle7 Server. For more information about the Trusted Oracle7 Server, see the Trusted Oracle7 Server Administrator's Guide, Release 7.1.