SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can client_info be set in SQL query which is not inside PL/SQL?

Roland MuellerAug 10 2017 — edited Aug 11 2017

Hello,

In a PL/SQL it's possible to set cleint_info for the actual DB session. After executing the following script call client_info column in v$session is set for every query.

SQL> exec dbms_application_info.set_client_info('my_client_INFO');

However, is there any mean to set client_info for queries executed through Perl DBI or JDBC or similar interfaces? May be using hints?

Regards,

Roland

This post has been answered by Roland Mueller on Aug 11 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 8 2017

Added on Aug 10 2017

11 comments

1,534 views