My Oracle Support Banner

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

Last updated on DECEMBER 21, 2020

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


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

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