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 .
oracle connector insert blob error
Moderators: chulett, rschirm, roy
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.
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.