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
Post a Comment