U0003590 DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-12899: value too large for column "<schema

Document ID : KB000089136
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
U0003590 DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-12899: value too large for column "
Resolution:
Detailed Description and Symptoms

?When doing an initial load of the Automic database object into an Oracle database, the AutomicDBLOAD utility errors with:

?

 

U0003590 DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-12899: value too large for column "&lt;schema>"."DIVDB"."DIVDB_STRING" (actual: 511, maximum: 255)'

 


Investigation

?Checking the DBLOAD log you see the following line for the database set-up:

U0003535 DB INFO: 'NLS_LENGTH_SEMANTICS           = BYTE'


Solution

?The database need to be set up to use CHAR

 

Per the documentation the database must be set with UTF-8 and NLS_LENGTH_SEMANTICS = CHAR.