Inserting Char Data > 4000 Bytes Into Clob With MSDAORA Fails With ORA-01460: Unimplemented Or Unreasonable Conversion Requested
(Doc ID 1423688.1)
Last updated on JANUARY 29, 2022
Applies to:
Oracle Provider for OLE DB - Version 10.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
Attempting to insert character Data that is greater than 4000 Bytes into a CLOB column using the Microsoft MSDAORA Fails With:
ORA-01460: Unimplemented Or Unreasonable Conversion Requested
The insert executes successfully if the database characterset is single byte. i.e WE8ISO8859P1
The insert fails if the database characterset is nulti-byte. i.e AL32UTF8
Exception Stack:
COM Error. COM Source: Microsoft OLE DB Provider for Oracle. COM Error message: Unspecified error :
ORA-01460: unimplemented or unreasonable conversion requested
. COM Description: ORA-01460: unimplemented or unreasonable conversion requested
. (error 10073)
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |