My Oracle Support Banner

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 NOVEMBER 18, 2019

Applies to:

Oracle Provider for OLE DB - Version 10.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 09-Sep-2013***

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.