kvsinfo wrote:Try creating an application item copying #OWNER# and using it instead. Since it is your own item you will be able to change the value
I have APEX 4.2 accesing thru pl/sql gateway, 11gR2 DB and using theme 24 cloudy.
I have a custom login screen below and its working fine.
Schema Name: xxx
User Name: xxxx
My goal is during login the user can select which schema to access. I have 1 workspace with 1 application and it is assigned to multiple schemas. I have 1 parsing schema (APEX_MSTR) and have several app schemas ( 'APPUSER1' AND 'APPUSER2') that all have the same table structures, emp and dept. Both schemas (APPUSER1 AND APPUSERS2) would have both emp and dept tables.