ADF VO bind variable based on an array - JBO25009
Hello,
How can I set for a bind variable the type array? I have a VO based on the following query
select t.* from
( select max(recid) recid_max,recid_ori
from tcddc where id_client in :p_id_client and id_card = (select id from tcard where tipCA='VBD')
AND tip_detinator = 'S' AND tip not in (3404,3411)
group by recid_ori )d , tcddc t
where
t.recid_ori=d.recid_ori
and t.recid=d.recid_max
and t.id_card=(select id from tcard where tipCA='VBD')and t.tip_detinator='S' and t.id_client in :p_id_client and t.tip not in (3404,3411).
How can I set p_id_client to receive an array or a list of values. When I've try to set bind variable expression adf.object.viewObject.p_id_client from impl I've receive JBO25009.
public void setp_id_client(Array value) {
String[] clientsList = new String[1];
clientsList[0]="123";
clientsList[1]="234";
value = new Array(clientsList);
setNamedWhereClauseParam("p_id_client", value);
}
How can I make a bind variable to receive a list of clients?
Thank you,
O.