Oracle - DBMS_APPLICATION_INFO.set_client_info - What is it and when to use

0

On the line below in a PL / SQL script

DBMS_APPLICATION_INFO.set_client_info ('1010103 @ company');

Got it that is a package calling a procedure and that it arrow customer information in the session (in my case it is the enrollment of the billing coordinator)

In case, will it put in the table as if it had done the script operation? Can you give more information on how this works? In the Output nothing appears, I do not understand where it arrow and why the @ company registration

    
asked by anonymous 13.06.2018 / 20:29

1 answer

1

The set_client_info function adds the information in the Client_Info field of the view V $ SESSION, according to the oracle documentation this field is to describe the application that is connected. It would have to see if your application uses the field somewhere or if it would just be for DBA control.

    
13.06.2018 / 20:48