Home > IT Answers > Development > Oracle -fetched column value truncated error
Shwetavyas
15 pts.
 Oracle -fetched column value truncated error
ASP.NET, C#, ORA-01406, Oracle, Oracle 9i, Oracle error messages
Hi I am using ASP.net using C# in my application which connects to Oracle 9i DB with a UTF8 character set. On of my columns in a table has datatype Nvarchar2(4000), when I try to fetch data through a Stored proecedure using execute Dataset command in C# it throws error "ORA 01406 -fetched column value truncated error " But this error does not occur if the datatype is changed to Nvarchar2(4000) Pls help Regards shweta

Software/Hardware used:
ASKED: May 22, 2008  7:31 AM
UPDATED: May 23, 2008  7:59 AM
RELATED QUESTIONS
Answer Wiki:
Your before and after datatype and data width are both the same. What's the initial and working datatype and data width?
Last Wiki Answer Submitted:  May 22, 2008  4:02 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

before it was Nvarchar2(4000), I changed it to Nvarchar2(2000), after changing it to 2000 , it does not throw the error

Shwetavyas
 15 pts.