Skip to Main Content

Java Development Tools

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!

how to execute bind variable value in LOV

thishumFeb 28 2013 — edited Feb 28 2013
hi all,
I am using ADF 11g 2 release. I need to execute my LOV when page load. In my lov sql has a bind variable called pavar , which is String value type. my LOV sql is like this:

select a, b, c from <tablename> where c='r'
and exists (select x from student_master where usrlvl=:pavar and unitcode='001')
union all
select a, b, c from <tablename> where c='r'
and exists (select x from student_master where usrlvl=:pavar and unitcode='001' and bankcode is null)
union all
select a, b, c from <tablename> where c='r'
and exists (select x from student_master where usrlvl=:pavar and unitcode='001' and bankcode is not null and lookupcode='0091')

bind varable is in diferent places in sql.
so in my backing bean I set variable value but it is not ok, because it is not a view criteria. so show me execute this sql. my BB has view_beforePhase(PhaseEvent phaseEvent) method.
I can bring the value of pavar to text field. but could not pass it to lov in run time.

pls tell me how to set bind variable value using programmatically in Backing bean.
thnks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 28 2013
Added on Feb 28 2013
15 comments
1,774 views