How to run oracle 10g Reports from Oracle Apex

Create bat file :

set ORACLE_HOME=c:\DevSuiteHome_1
set PATH=%ORACLE_HOME%\bin;%ORACLE_HOME%\jdk\jre\bin;%ORACLE_HOME%\jdk\jre\bin;%ORACLE_HOME%\jdk\jre\bin;%ORACLE_HOME%\jlib;%ORACLE_HOME%\jdk\bin

c:\DEVSUITEHOME_1\BIN\rwserver server=repsrvr autostart=yes

cgicmd :

sgmh: Userid=SGMH/S@ORCLPDB server=repsrvr destype=cache desformat=pdf %*

rwservlet.properties

SERVER_IN_PROCESS=YES
RELOAD_KEYMAP=YES
SERVER=repsrvr

--------------------------------------------------------------------------------------

CREATE TABLE LIERP.REPPARA
(
  ID         NUMBER(10),
  IP         VARCHAR2(30 BYTE),
  PORT       VARCHAR2(30 BYTE),
  URL        VARCHAR2(30 BYTE),
  CMDKEY     VARCHAR2(30 BYTE),
  DESFORMAT  VARCHAR2(30 BYTE),
  DESTYPE    VARCHAR2(30 BYTE)
);

insert into reppara values
(1,'192.168.0.201','8889','/reports/rwservlet','sgmh','pdf','cache');

COMMIT;

SET DEFINE OFF

create or replace FUNCTION F_PRINT_PARA
(
    vid        NUMBER,
    vPath      VARCHAR2,
    vReportNM  VARCHAR2,
    vParamForm VARCHAR2
) RETURN VARCHAR2
IS
    rep_url     VARCHAR2(2000);
    vIP         VARCHAR2(30);
    vPORT       VARCHAR2(30);
    vURL        VARCHAR2(200);
    vCMDKEY     VARCHAR2(30);
    vDESFORMAT  VARCHAR2(30);
    vDESTYPE    VARCHAR2(30);
BEGIN

    SELECT IP,PORT,URL,CMDKEY,DESFORMAT,DESTYPE
    INTO   vIP,vPORT,vURL,vCMDKEY,vDESFORMAT,vDESTYPE
    FROM   sgmh.reppara
    WHERE  id = vid;

    rep_url :=
        'http://' || vIP || ':' || vPORT || vURL ||
        '?cmdkey='    || vCMDKEY ||
        '&report='    || vPath || vReportNM ||
        '&desformat=' || vDESFORMAT ||
        '&destype='   || vDESTYPE ||
        '&paramform=' || vParamForm;

    RETURN rep_url;

EXCEPTION
    WHEN NO_DATA_FOUND THEN
        RETURN NULL;
END;
/

Dynamic Action :

WITHOUT PARA :

PLSQL :
-------

:P1_REP:=F_PRINT_PARA(1,'D:/REP_10g/','DEPT_WISE_EMP.rdf','no');

WITH PARA : -----------------

:P1_REP:=F_PRINT_PARA(1,'D:/REP_10g/','DEPT_WISE_EMP2.rdf','no'||'&p_dept='||:P1_DEPT);

JS:

var r_link = $v("P1_REP");
window.open(r_link);