SET_MODULE procedure - Set and register module name

The SET_MODULE procedure is used to set and register the name of the module that is currently being executed.

Syntax

Read syntax diagramSkip visual syntax diagramDBMS_APPLICATION_INFO.SET_MODULE(module_name ,action_name)

Procedure parameters

module_name

An expression that specifies the name of the current module. The value returned has a data type of VARCHAR(32672).

action_name

An expression that specifies the name of the current action. The value returned has a data type of VARCHAR(32672).

Authorization

EXECUTE privilege on the DBMS_APPLICATION_INFO module.

Examples

The following example shows a procedure call to set module_name and action_name values for the current module:

db2 " CALL DBMS_APPLICATION_INFO.SET_MODULE('<module name>', '<action name>')"