Hi All,
We are using datastage 8.5 ,and using oracle connect stage we are reading data ,and have one CLOB datatype colum which is taken as longvarchar(4000).but still i face error as below
The OCI function OCIStmtExecute returned status -1. Error code: 1,461, Error message: ORA-01461: can bind a LONG value only for insert into a LONG column. (CC_OraStatement::executeInsert, file CC_OraStatement.cpp, line 1,684)
Please help me out
CLOB datatype issue in datastage
Moderators: chulett, rschirm, roy
CLOB datatype issue in datastage
thanks n regards
nani
nani
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Ray,Thanks for your reply.
But when we remove CLOB datatype column,the job works fine without errors .
we had tried with other option too.In oracle connector stage properties ,we had given the LOB preference and mentioned the CLOB column name .this time we get the below error log as
The OCI function OCIStmtExecute returned status -1. Error code: 1,445, Error message: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table. (CC_OraStatement::executeSelect, file CC_OraStatement.cpp, line 2,893)
but we have not selected row id in the select query
Kindly suggest us
But when we remove CLOB datatype column,the job works fine without errors .
we had tried with other option too.In oracle connector stage properties ,we had given the LOB preference and mentioned the CLOB column name .this time we get the below error log as
The OCI function OCIStmtExecute returned status -1. Error code: 1,445, Error message: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table. (CC_OraStatement::executeSelect, file CC_OraStatement.cpp, line 2,893)
but we have not selected row id in the select query
Kindly suggest us
thanks n regards
nani
nani
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 72
- Joined: Mon Jul 06, 2009 9:34 pm
- Location: Sydney