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.