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!

The difference between :APP_SESSION and v('APP_SESSION')

Paul MooreJun 11 2009 — edited Aug 19 2009
Can someone clarify for me the difference between using the :APP_SESSION form for referencing substitution variables and the v('APP_SESSION') form? The reason I ask is that I had an application with a login form using the following call

wwv_flow_custom_auth_std.login(
P_UNAME => :P101_USERNAME,
P_PASSWORD => :P101_PASSWORD,
P_SESSION_ID => :APP_SESSION,
P_FLOW_PAGE => :APP_ID||':1'
);

This wasn't working (the session wasn't getting established properly). When I changed it to use v('APP_SESSION') for P_SESSION_ID, it started working.

I can't see any obvious reason why the 2 forms of reference would work differently - and I haven't been able to find a clear explanation of the distinction in the manuals (it's not easy to think of a good way of searching, so I may have missed something!)

Can anyone explain for me, please?

Thanks,
Paul.
This post has been answered by 60437 on Jun 11 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 10 2009
Added on Jun 11 2009
3 comments
6,414 views