OBIEE 11g Analysis Fails With Error - ORA-01706: User Function Result Value Was Too Large At OCI (Doc ID 2053535.1)

Last updated on SEPTEMBER 18, 2015

Applies to:

Business Intelligence Reporting and Publishing - Version 11.1.1.7.150120 and later
Information in this document applies to any platform.

Symptoms

OBIEE generated SQL SYS_OP_MAP_NONNULL(column1) = SYS_OP_MAP_NONNULL(column)

causes error:

 ORA-01706: user function result value was too large at OCI when column1 exceeds 2000 characters.

Column1 is defined as varchar2(4000 BYTE).

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