Hi,
In order to access any observations in a view, I first must run the following command once when logging in to SQL Developer:
begin
apps.mo_global.set_policy_context('S',org#) ;
end ;
If I query the view before running the command above, the dataset is returned but contains absolutely no observations. After running the command, I am able to view all of the observations in the view and can query it normally. Can someone explain why this command is necessary and if there are any other ways to avoid having to enter it each time I enter SQL developer? I have the same issue querying the view from other programs, such as SAS, and I am unable to find any other ways to access the observations in the desired view.
Any help or explanation on this would be much appreciated.
Thank you