Expanded non LONG bind data supplied after actual LONG or LOB column
Hi All, I have a target table which contains 10 columns. 4 out of 10 columns are clob data type columns. I'm loading data into this table. I have considered these columns as string of length 4000 each. But i'm getting below error when I run the job. "Expanded non LONG bind data supplied after actual LONG or LOB column"
I'm using TIS 5.1.1 and Oracle 11g. Kindly assist on how to handle this.
Do you have created the table with the output component? It would be great to see your create table statement. As far as I know, in a table is only ONE long data type allowed. The long data type is deprecated and should replaced by CLOB. Please check if your data types really CLOB and not LONG.
Hi jlolling,
Thanks for the reply.I'm not creating the output table with output component. There are no long datatype columns in my table. one column is number, 5 are string of length 500 and 4 are clob type.
"Expanded non LONG bind data supplied after actual LONG or LOB column"
This error imply that :A Bind value of length potentially > 4000 bytes follows binding for LOB or LONG. You can re-order the binds so that the LONG bind or LOB binds are all at the end of the bind list. Best regards Sabrina
Hi Sabrina,
I've reordered all the clob datatype columns at the last inside the tMap component while moving the data into target table. And I've used long datatype for these 4 columns in tMap. But originally these 4 columns are of clob datatype in DB. I'm still getting the same error.
Hi
I have talend job which is fetching the data from greenplum and moving into oracle database.in oracle db i have 3 columns as a CLOB datatype.while running the job i got below error
"Expanded non LONG bind data supplied after actual LONG or LOB column"
Please suggest me to fix this
