One Star

Issue on CLOB or BLOB datatype while insert in oracle.

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.
3 REPLIES
Employee

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

Hello,
You can follow 1543
Regards,
One Star

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

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

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

Sorry, see 2258