Oracle7 Server Tuning

Contents Index Home Previous Next

Registering Applications

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.


Contents Index Home Previous Next