ORA-01406: fetched column value was truncated

[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.

 

[Cor Ligthert[MVP]]

Onc,

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

Have for ADO a look in the DATA classes.

Cor

 

[onc]

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.

 

[Cor Ligthert[MVP]]

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

 

[onc]

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...