Home » RDBMS Server » Networking and Gateways » Oracle error "fetched column value was truncated"
Oracle error "fetched column value was truncated" [message #123731] Tue, 14 June 2005 10:51
pritamrp
Messages: 1
Registered: June 2005
Junior Member
Hello

When I run a query using a Windows XP machine using Oracle ODBC driver (10.01.00.31) against Oracle Database (version 10.1.0.2.0), I get the following error.

[Oracle][ODBC][Ora]ORA-01406: fetched column value was truncated
(1406)

The same sql works correctly if I add an order by clause.

Also if I connect to same database using ODBC driver version 9.02.00.00 and run the original query, it works without any error.

Am I right in thinking that this is a problem with the drivers? Also is this the right forum for this type of question. If not where can I find answer to the above question.

Regards

Pritam
Previous Topic: SQL over 2 domains
Next Topic: Need help to solve IP address for Oracle 10g
Goto Forum:
  


Current Time: Thu May 09 16:37:55 CDT 2024