Hi,
we have an old form application, which change application's looking schema in login page. In schemas, there are year based data. Schema names like ...2018, ...2017, ...2016 and so on ... If user select 2018 in login page, application schema set to ...2018 and so on.
Now we have to implement this in Oracle Application Express. (APEX version is 18.1.0.00.45.)
Assigned schemas to this workspace is as;
From Shared Components -> Security -> Security Attributes -> Database Session tab, I write the below code in Inıtıalization PL/SQL Code part, to check if it is possible.
BEGIN
APEX_APPLICATION.g_flow_owner := '...2017';
END;
And there is a page to check if it is working.
- The first report in page is **Interactive Report** derived from a sql like
_SELECT record\_no, transaction\_date, customer\_no, lot\_ordered FROM **#OWNER#.seans;**_
- The second region is **Classical Report** derived by
_SELECT record\_no, transaction\_date, customer\_no, lot\_ordered **FROM seans;**_
_-_ The third one is also a **Classical Report,** mapped to a **table as source**
In both cases, there is no change. Owner changed by APEX_APPLICATION.g_flow_owner := '...2017'; does not affect the test reports in page. All reports get data from apllication's main schema ...2018.
How could we implement this in APEX? Is there any way of doing this? Also the parsing schema, changed in login (if possible) should be for only that session or login. Another one selected another schema shold not change another ones selection.
Thanks in advance.
Kind regards.