Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Appending a value (Session ID) to a URL

540195Jun 23 2008 — edited Jun 23 2008
Hi All,

I have an apex page that has :

-Text Field (P2_SESSION_ID) that represent the session ID ( already populated with a valid session ID)
-A link that is basically in a PLSQL dynamic region and defined in a plsql variable , and the plsql code takes care of calling this variable (URL) when we click on that link ( or some button ).
like: v_action varchar2 := 'f?p=112:3'

My question is very simple :
Is there a way to "append" the value in P2_SESSION_ID to the v_action ?
i.e if P2_SESSION_ID value is '1111111..' , then I want the link to be 'f?p=112:3:111111'.

I tried many things like :
v_action varchar2 := 'f?p=112:3:&P2_SESSION_ID.' and
v_action varchar2 := 'f?p=112:3'||'&P2_SESSION_ID.' and
v_action varchar2 := 'f?p=112:3:P2_SESSION_ID'

But nothing worked! Can somebody help me to get the right syntax for the URL?

Thanks
Sam
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 21 2008
Added on Jun 23 2008
5 comments
1,107 views