Search This Blog

Wednesday, March 20, 2019

For Single Application .. Multiple Schema


You Can Use API

--Shared Component
---Security Attribute
-----Database Session
-------Initialization PL/SQL Code

DECLARE

BEGIN
IF UPPER(:APP_USER) = 'A' THEN 

APEX_UTIL.SET_PARSING_SCHEMA_FOR_REQUEST 
( P_SCHEMA => 'HR_A');

ELSE 
APEX_UTIL.SET_PARSING_SCHEMA_FOR_REQUEST 
( P_SCHEMA => 'HR_B');
END IF; 

END;

1 comment:

Restrict File Upload by File Type in Oracle Apex

If you want to restrict file upload by file type/extension/format you can follow the below steps.  Goto File Browser Item --> Advanced --...