Step-1: Enable Session cloning
Execute below command Under SYS:
1 2 3 |
apex_instance_admin.set_parameter( p_parameter => 'CLONE_SESSION_ENABLED', p_value => 'Y'); |
Step-2: Use of Session clone
Example: 1
1 |
select empno,ename,sal,'<a href="'||'f?p=108:2:&APP_SESSION.:APEX_CLONE_SESSION::2:P2_VAL:'||484848||'" target="_blank">'||'downloadDoc'||'</a>' as LINK from emp |