Getting An Error While Creating Test Profile In Test Drive In Dictionary Workbench - java.sql.SQLException: ORA-12899

(Doc ID 2224182.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Oracle Knowledge - Version 8.6 and later
Information in this document applies to any platform.

Goal

When trying to create a long comma separated value in "user.segment" , receiving the following error:

Error Message:
java.sql.SQLException: ORA-12899: value too large for column "INQUIRA_SEARCH"."CWB_TEST_PROFILE_VARS"."VARIABLE_VALUE" (actual: 1094, maximum: 1024)
 

Solution

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