2 Replies Latest reply on Sep 24, 2013 8:38 PM by user735415

    Question reading Clob value from ODI



      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!