ora-01460

[nodari]

I changed oracle server version 9i1 with 9i2. The queries, for example:

select cl_start_date, cl_acall, cl_cu_id, cl_country, cl_rcode
from littlecalls
where cl_start_date>='01-jan-2002' and to_char(cl_start_date, 'Mon')=:mon

which used to complete in the old version, face problems now and there occur such errors:

ORA-01460 unimplemented or unreasonable conversion requested

The queries

select cl_start_date, cl_acall, cl_cu_id, cl_country, cl_rcode
from littlecalls
where cl_start_date>='01-jan-2002'

complete, we use C++ builder 5.0.

Please advice how to solve the existing problem.

Thank you in advance,

Nodar

 

[Marco Kalter]

Perhaps you are now using a multi-byte character set in 9iR2? In that case you need to set TOracleSession.BytesPerCharacter to bcAutoDetect. If you already have this set, or if this doesn't help, you probably need a patch version for an Oracle9iR2 bug. Let me know if that is the case and I will arrange a patched C++Builder 5 version.

------------------
Marco Kalter
Allround Automations

 

[nodari]

Dear Marco,

Thank you very much for your kind support.
We indeed found your information very helpfull.

Nodar Zviadadze