2 Replies Latest reply: Sep 24, 2013 3:38 PM by user735415 RSS

    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!





        • 1. Re: Question reading Clob value from ODI

          Hi in ODI through Interafce and Model it won't work,


          If u are getting a file then create external table and just put the Insert Scipt in ODI Procedure.


          if ur moving data from table to table then it will be same thing, create a procedure with Insert Script.

          • 2. Re: Question reading Clob value from ODI


            Thanks for your reply.

            In my case, I need to get text value from table (which is stored in CLOB column) and store the text value in to ODI variable like #filter.

            So basically, I need to know how to read clob column from table if the text value is more than 4000 characters.

            Later I need to use the #filter variable in ODI interface's filter.