error on Oracle connector stage
Moderators: chulett, rschirm, roy
error on Oracle connector stage
Hi,
I have a problem with Oracle connector stage in job when it is reading the data from table. It is given below error please help me to resolve the error.
The OCI function OCIStmtFetch returned status -1. Error code: 1,406, Error message: ORA-01406: fetched column value was truncated. (CC_OraConnection::logOracleNlsSessionParameters, file CC_OraConnection.cpp, line 3,579)
I have a problem with Oracle connector stage in job when it is reading the data from table. It is given below error please help me to resolve the error.
The OCI function OCIStmtFetch returned status -1. Error code: 1,406, Error message: ORA-01406: fetched column value was truncated. (CC_OraConnection::logOracleNlsSessionParameters, file CC_OraConnection.cpp, line 3,579)
ravikumar
It would seem that your job definition for one of the columns isn't big enough to fit the actual data. Compare your metadata in the actual table with what you have in the job.
When I see "nls" in the error message I wonder if you might have declared the table with "bytes" rather than "characters" in Oracle. That can cause this type of an error with multibyte characters.
When I see "nls" in the error message I wonder if you might have declared the table with "bytes" rather than "characters" in Oracle. That can cause this type of an error with multibyte characters.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
I did explain, but perhaps that part of the message was in the premium content portion. When using NLS there is a difference between string size when the table is defined as character rather than byte sized.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
How many characters have you defined in the string and how many are in the string causing the error message?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
2 what? 88 what?
You need to be more precise in your questions and replies so people can help you. Does your source table have an unbound number in it? Meaning one like NUMBER rather than NUMBER(15) or any other precision. Does it have a LOB column, like a CLOB or BLOB? Is your database set up with a multibyte characterset? As Arnd notes, the default is typically "byte semantics" in Oracle and thus a VARCHAR2(5) field holds five bytes rather than five characters. These can all cause that error.
If you are unsure about any of the answers, check with your DBA.
You need to be more precise in your questions and replies so people can help you. Does your source table have an unbound number in it? Meaning one like NUMBER rather than NUMBER(15) or any other precision. Does it have a LOB column, like a CLOB or BLOB? Is your database set up with a multibyte characterset? As Arnd notes, the default is typically "byte semantics" in Oracle and thus a VARCHAR2(5) field holds five bytes rather than five characters. These can all cause that error.
If you are unsure about any of the answers, check with your DBA.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers