Thursday, 11 November 2021

Oracle Apps - SQLDEVELOPER is not returning data from Oracle Standard Policy Based Tables even after setting Policy Context

Sometimes SQLDEVELOPER is not returning data from Oracle Standard Policy Based Tables even after setting the policy context


i.e. 

MO_GLOBAL.SET_POLICY_CONTEXT('S', 83);

select * from org_organization_definitions; is returning 0 results


Proposed Solutions: 

Add this line in sqldeveloper.conf file and try one more time

 
AddVMOption -Doracle.net.disableOob=true

No comments:

Post a Comment