Devart Forums

Posted: **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

Posted: **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.....

Posted: **Wed 15 Mar 2006 09:42**

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

Posted: **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

Posted: **Mon 20 Mar 2006 08:54**

hi,
can you reproduce my Problem ?

Posted: **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.

Posted: **Tue 21 Mar 2006 16:24**

I have send to you a email with dump.

Posted: **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

Posted: **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 !

Posted: **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

Posted: **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)

Posted: **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

Posted: **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

Devart Forums

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

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