This discussion is archived
2 Replies Latest reply: Sep 24, 2013 1:38 PM by user735415 RSS

Question reading Clob value from ODI

user735415 Newbie
Currently Being Moderated


I have an ODI technical question to read Clob value from ODI.

I need to read Clob value from a table and assign the value to a variable.

I can do it by a variable step with something like following query in its Refreshing tab:


     Select TO_CHAR( Select filter_condition      // The filter_condition is Clob column
                                 From arm_settings
                                 Where user_id='GLOBAL')
     From fcm_settings
     Where user_id='GLOBAL'

Now the problem is 4000 characters limitation.

If the text size in filter_condition clob column is more than 4000 characters then I will have a problem.

Do you know how to solve this problem from ODI?

Thanks for your help in advance!






  • Correct Answers - 10 points
  • Helpful Answers - 5 points