Tuesday, July 5, 2011

How to set ORG ID in PL/SQL

11i
BEGIN
DBMS_APPLICATION_INFO.SET_CLIENT_INFO('ORG_ID');
END;

R12
BEGIN
MO_GLOBAL.SET_POLICY_CONTEXT('S',
ORG_ID);
END;

No comments:

Post a Comment