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 IN VARCHAR2 DEFAULT NULL, p_value3 IN VARCHAR2 DEFAULT NULL, p_name4 IN VARCHAR2 DEFAULT NULL, p_value4 IN VARCHAR2 DEFAULT NULL, p_name5 IN VARCHAR2 DEFAULT NULL, p_value5 IN VARCHAR2 DEFAULT NULL, p_name6 IN VARCHAR2 DEFAULT NULL, p_value6 IN VARCHAR2 DEFAULT NULL, p_name7 IN VARCHAR2 DEFAULT NULL, p_value7 IN VARCHAR2 DEFAULT NU
by Karkuvelraja Thangamariappan ♠ (@tkarkuvelraja)