Page 1 of 1

oracle connector insert blob error

Posted: Mon Oct 11, 2010 8:34 pm
by xjlibin1
I use datastage 8.1.0.1(fixpack1) on windows ,and just made a simple job using two oracle connector direct link together to test how lob work.
two table in the same oracle schema and have same data structure(both has a blob field),when i insert a blob about 2-5M ,i can run the job successfully,and when the blob bigger than about 5M ,then error log shows below error:

Oracle_Connector_1,0: [IIS-CONN-ORA-001003] The OCI function OCIStmtSetPieceInfo returned status -1. Error code: 24,307, Error message: ORA-24307: invalid length for piece. (CC_OraStatement::piecewiseInsertLobParameters, file CC_OraStatement.cpp, line 3,716)
[IIS-CONN-ORA-001003] The OCI function OCITransRollback returned status -1. Error code: 3,127, Error message: ORA-03127: no new operations allowed until the active operation ends. (CC_OraConnection::endLocalTransaction, file CC_OraConnection.cpp, line 1,098)


Oracle_Connector_1,0: [IIS-CONN-ORA-001003] The OCI function OCIHandleFree:OCI_HTYPE_STMT returned status -1. Error code: 3,127, Error message: ORA-03127: no new operations allowed until the active operation ends. (CC_OraStatement::~CC_OraStatement, file CC_OraStatement.cpp, line 129)
[IIS-CONN-ORA-001003] The OCI function OCIHandleFree:OCI_HTYPE_SERVER returned status -1. Error code: 3,127, Error message: ORA-03127: no new operations allowed until the active operation ends. (CC_OraConnection::disconnect, file CC_OraConnection.cpp, line 983)

so i want to know if there is some paramter can void this situation. hope you can help me .

Posted: Mon Oct 11, 2010 10:52 pm
by xjlibin1
when I use "enable lob reference" in oracle connector ,then i got a different error
in director logs,seems like a oracle error,
Oracle_Connector_1,0: [IIS-CONN-ORA-001003] The OCI function OCIStmtExecute returned status -1. Error code: 12,571, Error message: ORA-12571: TNS:packet writer failure. (CC_OraStatement::executeInsert, file CC_OraStatement.cpp, line 1,257)
[IIS-CONN-ORA-001003] The OCI function OCITransRollback returned status -1. Error code: 3,114, Error message: ORA-03114: not connected to ORACLE. (CC_OraConnection::endLocalTransaction, file CC_OraConnection.cpp, line 1,098)
hope experts give me some tips on this issue.

Posted: Tue Oct 12, 2010 8:35 pm
by xjlibin1
is this problem a oracle issues.