Home > IT Answers > Oracle > Oracle -fetched column value truncated error
Help

Question

  Asked: May 22 2008   7:31 AM GMT
  Asked by: Shwetavyas

Oracle -fetched column value truncated error


Oracle, ORA-01406, C#, ASP.NET, Oracle error messages, Oracle 9i

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

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: May 22 2008  4:02 PM GMT  by Mrdenny




Your before and after datatype and data width are both the same. What's the initial and working datatype and data width?
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Oracle and Development.

Looking for relevant Oracle Whitepapers? Visit the SearchOracle.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Shwetavyas  |   May 23 2008  7:59AM GMT

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