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 and later
Information in this document applies to any platform.


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).


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