Hi,
I am using a Search VO to show three fields like a, b, c.
My VO query is selet '' a,''b,''c from dual.
For these 3 attributes I have created three different LovVO's with queries to display from database.
select a from table1 -- retrun values like a1,a2,a3
select b from table1.--return values like b1,b2,b3
select c from table1.--return values like c1,c2,c3
Based on the input parameters I am searching data and I am also deleting data from Database using callable statement.
For Eg: I select a1 from lov from a attribute and search and hit delete button. record a1 will be deleted from DB but still it showing in picklist of attribute a.
Upon deleting i want to refresh my pick list.
How can I do this? Please advise.
Thanks,