SET_CLIENT_INFO

The SET_CLIENT_INFO procedure is used to set additional information about the client application.

Syntax

DBMS_APPLICATION_INFO.SET_CLIENT_INFO (
client_info IN VARCHAR2);

Parameters

The client_info parameter stores any additional information about the client application. This information is stored in the __all_virtual_processlist table. If the information exceeds 64 bytes, it will be truncated.

Examples

DECLARE
    myclient VARCHAR2(100);
      ...
   BEGIN
      ...

      DBMS_APPLICATION_INFO.SET_CLIENT_INFO('myclient');
      DBMS_OUTPUT.PUT_LINE ('client='||myclient);
   END;