OBIEE 11g Analysis Fails With Error - ORA-01706: User Function Result Value Was Too Large At OCI
Last updated on SEPTEMBER 18, 2015
Applies to:Business Intelligence Reporting and Publishing - Version 188.8.131.52.150120 and later
Information in this document applies to any platform.
OBIEE generated SQL SYS_OP_MAP_NONNULL(column1) = SYS_OP_MAP_NONNULL(column)
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