ORA-01406: fetched column value was truncated

  • Thread starter Thread starter onc
  • Start date Start date
O

onc

Using data reader against one of my Oracle tables is crashing with following
error:

System.Data.OracleClient.OracleException: ORA-01406: fetched column value
was truncated.

This happens with Microsoft ADO driver to Oracle. Oracle ADO driver works
just fine.
Error happens only with some records (there are some pretty large columns in
a table), but not other.

I wonder if anyone has any insights to this issue – we don’t want to compile
Oracle drivers into our base applications, because most of our customers are
using SQL Server.

Thanks in advance.
 
Onc,

Be aware that this is an ADONET newsgroup and not ADO.

Have for ADO a look in the DATA classes.

Cor
 
Forgive my confusion, but I am using dotnet - the code is in C# and error
clearly is from the dotnet assembly System.Data:

System.Data.OracleClient.OracleException: ORA-01406

If this is not considered ADONET - then I would appreciate some explanation
so I am not doing the same mistake in a future.

Best Regards.
 
Mayb can you give more information to be able to solve your problem for
Ocal.
Are you using a Ocal provider or a Microsoft provider, the given reply does
not look as a Microsoft Exception, probably it is from Ocal

Cor
 
I am using both - Microsoft driver is crashing and Oracle one does not.
Error no doubts is coming from the database engine, not the driver.
From Oracle documentation - this error means that client (in this case
Microsoft driver) did not allocate buffer large enough to receive data from
the engine.

I can put together sample project, but I am not sure if volunteers can do
anything with this - I hoped MS monitors can step in...
 
Back
Top