how to execute bind variable value in LOV
thishumFeb 28 2013 — edited Feb 28 2013hi 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.