Question

9
Replies
3703
Views
DPSSingh Member since 2009 53 posts
JPMC
Posted: 4 years ago
Last activity: 4 years 8 months ago
Closed
Solved

How do we pass comma separated values to RDB_list

Hi All - I am having trouble passing dynamically generated comma separated values in an activity to an IN CLAUSE of where clause of RDB-List rule. I am storing it in a property and then using the property reference in RDB rule using ASIS keyword but instead od considering it a comma separated values inside "IN CLAUSE" it is treating it as single string. How do I tell system to consider it as comma separated values and not a single string?

We tried creating a Oracle function but could not make it work for all scenario - this function works well till length of comma separated values is less than 4000 characters (max limit of varchar2). We tried to make function parameter of TYPE CLOB but it still gives ORA-01704: string literal too long.

you may ask that why am I not using the inner query to feed in all comma separated values to main query - The reason we are unable to use inner query is because the inner query get values from one database and main query runs against another database.

Any help would be highly appreciated. Thanks!

Data Integration
Moderation Team has archived post
Share this page LinkedIn