Oracle Reports (MOSC)

MOSC Banner

passing multiple value in the parameter

edited Sep 4, 2012 4:01PM in Oracle Reports (MOSC) 5 commentsAnswered
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center