Dhirendra Pal Singh (DPSSingh)

DPSSingh Member since 2009 53 posts
Posted: December 22, 2015
Last activity: January 6, 2016
Posted: 22 Dec 2015 17:10 EST
Last activity: 6 Jan 2016 13:08 EST

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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.