About Oracle and Oracle ā'pěks (#orclapex)

Step 1:  Allow user to create any directory in database . GRANT CREATE ANY DIRECTORY TO scott; GRANT DROP ANY DIRECTORY TO scott; Step 2:  Create directory . CREATE OR REPLACE DIRECTORY temp AS '/d08/temp'; Step 3:  Give access to the directory . GRANT READ, WRITE ON DIRECTORY temp TO scott; optional: (REVOKE WRITE ON DIRECTORY tmp FROM scott) Step 4:  View database directories . SELECT  *    FROM all_directories; Note: You must have DBA rights, if you don't have DBA rights, you will get an error  "Invalid Directory Path". Related Posts: Move BLOB files into Oracle Directory Check if file exists in Oracle Directory

Objective : To integrate Oracle BI Publisher with Oracle Apex.  Step 1:  Create a procedure using below given PLSQL coding, which integrate Oracle BI with Oracle Apex. CREATE OR REPLACE PROCEDURE "WEB_SERVICES_CALL" (    p_name1         IN  VARCHAR2 DEFAULT NULL,    p_value1          IN   VARCHAR2 DEFAULT NULL,    p_name2            IN  VARCHAR2 DEFAULT NULL,    p_value2            IN   VARCHAR2 DEFAULT NULL,    p_name3           ...