ORA-01460: unimplemented or unreasonable conversion requested

[vsabu]

Hi All,

We are currently getting a following error

ORA-01460: unimplemented or unreasonable conversion requested

When we try to insert a double-byte character from our ASP.Net
application through ODP.Net version 9.

We have our server setting for UTF 8 encoding.

This works when we insert diretly through a query or executing the
stored proc with the same value using the backend.

But the above error is trigerred when we try to do the insert through
the ODP Parameter. The Datatype we tried include NVarchar2 and
Varchar2.

Note:
We have made this work by passing datatype as NClob.

Like to more information about this error and how to solve it?

Regards,
Syed.

 

[Paul Clement]

¤ Hi All,
¤
¤ We are currently getting a following error
¤
¤ ORA-01460: unimplemented or unreasonable conversion requested
¤
¤ When we try to insert a double-byte character from our ASP.Net
¤ application through ODP.Net version 9.
¤
¤ We have our server setting for UTF 8 encoding.
¤
¤ This works when we insert diretly through a query or executing the
¤ stored proc with the same value using the backend.
¤
¤ But the above error is trigerred when we try to do the insert through
¤ the ODP Parameter. The Datatype we tried include NVarchar2 and
¤ Varchar2.
¤
¤ Note:
¤ We have made this work by passing datatype as NClob.
¤
¤ Like to more information about this error and how to solve it?

Does this occur with Microsoft's .NET Provider for Oracle?

You might want to check with Oracle:

https://metalink.oracle.com/


Paul
~~~~
Microsoft MVP (Visual Basic)