How to pass comma separated values as input parameter in BIP – Oracle Fusion Applications
Sample Code
SELECT
hp.party_id, hp.party_Number, hp.party_name
FROM hz_parties hp
where 1=1
and hp.party_number IN
( select regexp_substr (
:P_PARTY_NUM_CSV,
'[^,]+',
1,
level
) value
from dual
connect by level <=
length ( :P_PARTY_NUM_CSV ) - length ( replace ( :P_PARTY_NUM_CSV, ',' ) ) + 1 )
Comments |0|
Category: BIP