ORA-1460 in release 8.5.10

[wchris]

ORA-1460 "unimplemented or unreasonable conversion requested"

with oracle 9.2.0.1 in OCI mode

net mode is ok

rollbacked to ODAC 8.2.7 which is ok

[AlexP]

Hello,

Please describe in more details the steps leading to this error and provide the scripts for creating DB objects working with which causes this error, and specify the version of your IDE.

[wchris]

Please describe in more details the steps leading to this error and provide the scripts for creating DB objects working with which causes this error, and specify the version of your IDE.

IDE Version is DELPHI 2007 build 11.0.2902.10471

we are in the process of migrating to XE2 so I could check with ODAC 8.5.10 and XE2, no problem

the problem is only with D2007 + ODAC 8.5.10 + OCI

unfortunately our production version is still D2007

Sorry I would like to help more, but I got confused while trying to reproduce the problem.

* First I connected to the customer database via VPN and got the same error with D2007 + OCI.

* Then I installed ODAC 8.5.10 for XE2 on the same machine and tested with XE2, everything was fine.

* Problem, and this is where I got confussed, now when I run the unchanged D2007 exe it works without error. I know this doesn't make sense, but it's just like ODAC install fixed oracle OCI !

Of course the customer where I didn't install ODAC still has the problem. But I cannot install ODAC on all his machines...

I don't know where I got it wrong


I continue my searchs : what else ?

I have a 10.2.0.5 client and the custommer has a 9.2.0.1 client

when I thansfer the XE2 executable (that always worked on my station) I get the ORA-1460 error like with the D2007 exe. (database is also oracle 9.2.0.1 like client)

My latest conclusion is this is more an oracle 9 related problem.

I have to stop searching for today. Maybe you can test any applicaion with oracle 9 ?

[AlexP]

Hello,

Please specify the query text which leads to the error and the scripts for creating and filling the tables used in this query, and we will try to reproduce the problem on our Oracle servers.

[wchris]

Hello,

Please specify the query text which leads to the error and the scripts for creating and filling the tables used in this query, and we will try to reproduce the problem on our Oracle servers.

YES ! got it !

Finally it's not an oracle 9 only problem, we have another customer with oracle 10g and the same error, so i't just OCI related.

in short when we add

OraSession.Options.Charset := 'WE8ISO8859P15';

it returns an ORA-01460 in OCI mode but not in NET mode. Which is inconsistent.

I have a small demo, now I have to find support mail

PS: we do this for years, we have ODAC since V4 and did always set charset like this. i's not a change from our side.

[AlexP]

Hello,

Thank you for the information.
We have reproduced the problem.
We will try to fix it in the nearest product version.

[wchris]

Hello,

Thank you for the information.
We have reproduced the problem.
We will try to fix it in the nearest product version.

Great fast and efficient like always.

[AlexP]

Hello,

We have already fixed the problem.
This fix will be included in the next build.
The next build will be released this week.