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!

Bind Variable issue - Interactive report

684605Mar 19 2009 — edited Mar 19 2009
From a "Select List with Submit", I'm constructing a SQL that looks like -

select * from emp
where :P1_SELECT_LIST_VALUE = 'Y'

When I look at the session, the value passes from the select list is correct and if I run the query with the hardcoded column value, a few records are returned.
BUT, this binding does not work.

i.e when I run the above query in SQL Commands - and I bind COLUMN_X to :P1_SELECT_LIST_VALUE, it DOES NOT WORK!

Am I missing something here? My thinking is that APEX is substituting the bind variable within quotes????

thanks,
p
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 16 2009
Added on Mar 19 2009
1 comment
657 views