passing multiple value in the parameter
the following is in the query
WHERE
NETV_INVOICE.TRX_NUMBER =:para_trx_id
and
NETV_INVOICE.ORG_ID =:AS_ORG_ID
AND NETV_INVOICE.RINV_F1 =:para_order_no
&CP_Param
&CP_Paramb
and following is in after parameter form
function AfterPForm return boolean is
begin
:CP_Param := ' and NETV_INVOICE.TRX_NUMBER in ('||:PARA_TRX_ID||')';
:CP_Paramb := ' and NETV_INVOICE.RINV_F1 in ('||:PARA_ORDER_NO||')';
return (TRUE);
end;
I am able to out put 1 single value for both para_order_no and :para_trx_id
but not able to output multiple for both parameter
0