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.
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.