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

Asked

Viewed 339 times

0

About the line below in a PL/SQL script

DBMS_APPLICATION_INFO.set_client_info('1111@Blabla');

I get it which is a package calling a trial and that it arrow customer information in the session (in my case is the registration of the billing coordinator)

In case, will it put on the table as if she had done the script operation? Can you give more information about how this works? Output does not show anything, I did not understand where he arrow and why he enrolled

1 answer

1

The function set_client_info 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. You would have to see if your application uses the field somewhere or if it would only be for DBA control.

Browser other questions tagged

You are not signed in. Login or sign up in order to post.