i've an apex application installed on Oracle Xe.
This application read and write data on the Erp's Database (Oracle 11g) so it could be consider as an extension of the Erp.To read and write data on Erp i use db links.
On the Erp's Database there're many schemas, one for each company of our group.
Due to this configuration of the db i need to reply the same possibility to the apex application (access of alla the companies to different schema's).
Which's the best way to do that ?
i could use apex_application.g_flow_owner to change the owner but i need to put #OWNER# all tables and procedure's names.
I'd like to change the parsing schema but i've not found the way to do that. Is it possibile?
In this picture you can see what i've done to show the actual company of the user and clicking the name of the company the user could change the current company (because one user could work for many companies)
Thanks