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 SEPTEMBER 09, 2013

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms