CLOBs Returning Incorrect Value Using AdUseServer (Doc ID 464083.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Provider for OLE DB - Version: 10.2.0.2.20 and later   [Release: and later ]
Microsoft Windows (32-bit)

Symptoms

A CLOB returns an incorrect value when selected using OLEDB in the following query

"
SELECT TABLE_A.domainconstraints
FROM TABLE_A
, TABLE_B
"

The Text field should show the value of the CLOB as
<DomainConstraints></DomainConstraints>

However instead it appears as
<DomainConst AAAMwHAAEAAAAD0AAA AAAMwGAAEAAAADsAAA


Works if Using adUseClient (but not adUseServer)

Works if the SELECT statement is changed to only include a single table.
.

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