Call Oracle APEX From Oracle Form

 PROCEDURE call_apex_page IS

 v_session  varchar2(30);

 vc_url   VARCHAR2(180);

BEGIN

  select dbms_session.unique_session_id into v_session from dual;

  vc_url := 'https://timbuktu.com/dev/f?p=2000:60:'||v_session||'::::P60_STUDENT_ID:'||NAME_IN('student_blk.student_id')||':';

 vc_url := REPLACE(vc_url,'<','%3c');

  vc_url := REPLACE(vc_url,'>','%3e');

  web.show_document(vc_url,'_blank');

END;

Comments