Issue on CLOB or BLOB datatype while insert in oracle.

Anonymous — Sat, 16 Nov 2024 14:31:47 GMT

Hi,
I am getting "Invalide Column" and "table or view doesnot exists" (randomnly) while processing CLOB and BLOB fields in oracle table. I am retrieving data using tOracleInput and inserting
data using tOracleOutput components directly. I have a schema definition for a column as below. (i gave one column for eg.).
I am using TOSv2.2.1.

Column : RESPONSE
DBColumn : RESPONSE
Type : Object
DBType : CLOB
When i went thru the generated java code, found the following.
Data Retrieval:
===============
if (colQtyInRs_tOracleInput_1 < 10) {
row1.RESPONSE = null;
} else {
if (rs_tOracleInput_1.getObject(10) != null) {
row1.RESPONSE = rs_tOracleInput_1.getObject(10);
} else {
row1.RESPONSE = null;
}
}

Data Insert:
=============
if (row1.RESPONSE == null) {
pstmt_tOracleOutput_1.setNull(10, java.sql.Types.OTHER);
} else {
pstmt_tOracleOutput_1.setObject(10, row1.RESPONSE);
}

Instead of rs_tOracleInput_1.getObject() and pstmt_tOracleOutput_1.setObject() , we should use getClob() and setClob() methods.
Kindly validate.

Thanks.

Re: Issue on CLOB or BLOB datatype while insert in oracle.

Anonymous — Sun, 28 Oct 2007 20:47:47 GMT

Hello,
You can follow 1543
Regards,

Re: Issue on CLOB or BLOB datatype while insert in oracle.

Anonymous — Mon, 29 Oct 2007 02:43:21 GMT

Dear mhirt,
I am not getting you.. The link which you gave is showing the same page again.
Regards.

Re: Issue on CLOB or BLOB datatype while insert in oracle.

Anonymous — Mon, 29 Oct 2007 09:11:02 GMT

Sorry, see 2258

topic Re: Issue on CLOB or BLOB datatype while insert in oracle. in Talend Studio

Issue on CLOB or BLOB datatype while insert in oracle.

Re: Issue on CLOB or BLOB datatype while insert in oracle.

Re: Issue on CLOB or BLOB datatype while insert in oracle.

Re: Issue on CLOB or BLOB datatype while insert in oracle.