ORA-12899

Hi All,

I'm not able to insert rows into the table due to below errors, i tried to increase the length but no luck,

SQL> alter session set nls_length_semantics = byte; (doesnt work with char as well)

Session altered.

SQL> alter  table ABC.TEST modify (UNIT_OF_MEASURE varchar2(9 BYTE));

Table altered.

desc ABC.TEST

UNIT_OF_MEASURE   VARCHAR2(9)

09.31.05 SQL Error: ORA-12899: value too large for column "ABC"."TEST"."UNIT_OF_MEASURE" (actual: 3, maximum: 1) 

INSERT /*+ APPEND*/ INTO TEST ( BUSINESS_UNIT , PROJECT_ID ,

ACTIVITY_ID , BUSINESS_UNIT_GL , COUNTRY , TESTTRAN_TYPE , TESTYEAR , PERIOD ,

DEPTID , PRODUCT , CHARTFIELD1 , CHARTFIELD2 , ANALYSIS_TYPE , RESOURCE_TYPE