ORA-01406: fetched column value was truncated

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
Wed Feb 27 22:41:58 CST 2008

Onc,

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

Have for ADO a look in the DATA classes.

Cor


"onc" <onc@discussions.microsoft.com> schreef in bericht
news:F06F7B90-B9D3-43E1-B402-815EF1D6BB31@microsoft.com...
> 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
Thu Feb 28 08:51:05 CST 2008

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]" wrote:

> Onc,
>
> Be aware that this is an ADONET newsgroup and not ADO.
>
> Have for ADO a look in the DATA classes.
>
> Cor

Cor
Thu Feb 28 12:06:21 CST 2008


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
Mon Mar 03 17:11:01 CST 2008

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



"Cor Ligthert[MVP]" wrote:

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