Technology Stack - EBS (MOSC)

MOSC Banner

How to DBMS_APPLICATION_INFO.SET_CLIENT_INFO(<value>)

edited Aug 20, 2021 11:26AM in Technology Stack - EBS (MOSC) 2 commentsAnswered
Hi Gurus,                                                                                                                
Question about this particular package.                                                                                  
Can i use DBMS_APPLICATION_INFO.SET_CLIENT_INFO(<value>) package after a select statement that the <value> will come from.
Like:                                                                                                                    
  Select org_id                                                                                                            
  into v_org_id                                                                                                            
  from hr_operating_units;                                                                                                 
  DBMS_APPLICATION_INFO.SET_CLIENT_INFO(v_org_id);                                                                         
                                                                                                                         
Could someone direct me to documentations and references regarding this package i.e. what/how to use.                    
                                                                                                                         
TIA!                                                                                                                     
Regards,                                                                                                                 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center