[ODAC 5.70.0.29 CLR]Error ORA-01406: fetched column value was truncated

nschmied · Post by **nschmied** » Mon 13 Mar 2006 15:09

Hi everyone,

I have a problem and I am seeking some help.
I'm using Odac with Oracle 10g 10.2.0.2.0(client and Database) and I get an error in a certain situation.

I get the following error : ORA-01406: fetched column value was truncated

Steps to error :

1. Have Oracle DB 10g 10.2.0.2.0 with AL32UTF8 charset
2. Create table

Code: Select all

CREATE TABLE TEST_FETCH
(
  TEST_FETCH_ID  NUMBER,
  TEST_DESCR     VARCHAR2(10 CHAR)              NOT NULL
)

3. Insert fields

Code: Select all

INSERT INTO TEST_FETCH ( TEST_FETCH_ID, TEST_DESCR ) VALUES ( 
1, 'SAMPLE'); 
INSERT INTO TEST_FETCH ( TEST_FETCH_ID, TEST_DESCR ) VALUES ( 
2, 'TEST'); 
INSERT INTO TEST_FETCH ( TEST_FETCH_ID, TEST_DESCR ) VALUES ( 
3, 'USER 1'); 
INSERT INTO TEST_FETCH ( TEST_FETCH_ID, TEST_DESCR ) VALUES ( 
4, '123456789é'); 
COMMIT;

4. Now test this table with the Odac Smart Demo .Net version.
Use these options :
FetchAll := true;
OraSession.Option.Useunicode := true;

This Sql Command :

Code: Select all

SELECT * FROM TEST_FETCH
ORDER BY TEST_FETCH_ID

When I click on "Open", I get the error described above. From what I can make out, it seems it is the TEST_FETCH_ID 4 which generates the error.

Can someone please help ?
Thanks

nschmied · Post by **nschmied** » Tue 14 Mar 2006 14:08

Hi,

Have you found a solution ? If you not found a solution, I have a big probleme, because I needs oracle10g 10.2.0.2.....

Challenger · Post by **Challenger** » Wed 15 Mar 2006 09:42

We tried this situation on different servers but couldn't reproduce the problem.

nschmied · Post by **nschmied** » Thu 16 Mar 2006 06:47

It's very important to make test with Oracle DB 10g 10.2.0.2.0 and set NLS_INSTANCE_PARAMETERS, NLS_LENGTH_SEMANTICS=CHAR.

If you want, I send you a small dump ?

N.Schmied

nschmied · Post by **nschmied** » Mon 20 Mar 2006 08:54

hi,
can you reproduce my Problem ?

Alex · Post by **Alex** » Mon 20 Mar 2006 16:03

We still can't reproduce the problem.
Please check if this problem persists with win32 Demo.
It would be useful if you can send us the small dump.

nschmied · Post by **nschmied** » Tue 21 Mar 2006 16:24

I have send to you a email with dump.

nschmied · Post by **nschmied** » Mon 27 Mar 2006 11:32

I have make test with a winForm client that use OPD.NET from Oracle.
And It's work fine.
The error decome from ODAC.
Sorry

NSchmied

nschmied · Post by **nschmied** » Mon 27 Mar 2006 11:46

I have make test with version win32 of Smart.exe, and it's work fine.

Also this error is only in DotNET version of ODAC !

nschmied · Post by **nschmied** » Thu 30 Mar 2006 16:29

Hi,
Have you received my Dump ?

Have you found a solution ?

It's important for me to be able to solve this problem.

Thanks,
Nschmied

Challenger · Post by **Challenger** » Fri 31 Mar 2006 08:23

Yes, we recived your dump and imported it. But we still couldn't reproduce this error. Please try to connect to server using another client (for example, Oracle 9)

nschmied · Post by **nschmied** » Mon 03 Apr 2006 09:47

Hi,
I have make new test with more large data. I send to you a new dump with a new table PC_BASIC_OBJECT_DESCR.
with this table use this sql command

Code: Select all

select BOD_DESCR from pc_basic_object_descr
where pc_lang_id = 1

And I hope it's raise a OraError

nschmied

nschmied · Post by **nschmied** » Mon 03 Apr 2006 09:50

nschmied wrote:I have make test with version win32 of Smart.exe, and it's work fine.

Also this error is only in DotNET version of ODAC !

With this new table PC_BASIC_OBJECT_DESCR, Win23 version of ODAC doesn't work.

nschmied