I get this error when my Java application tries to insert a record: java.sql.SQLException: ORA-12899: value "T1"."SYS_NC00164$" too large (actual: 27, expected: 19). I guess the mentioned column is a system-maintained one but for what Oracle uses it? How can I troubleshoot this error?
Oracle : 11g Release 11.2.0.1.0 - 64bit Production
JDBC Driver: ojdbc6
Table definition:
create table T1 (RowUID NUMBER, PROFILE_ID VARCHAR(40), OPERATION VARCHAR(40), CONTROL CLOB, ff1 VARCHAR(4000), ff2 VARCHAR(4000), ff3 VARCHAR(4000), ff4 VARCHAR(4000), ff5 VARCHAR(4000), ff6 DATE, ff7 DATE, ff8 VARCHAR(4000), ff9 VARCHAR(4000), ff11 VARCHAR(4000), ff12 NUMBER, ff13 VARCHAR(4000), ff10 VARCHAR(4000), frame_0 POSC.FRAME_TYPE, frame_1 POSC.FRAME_TYPE, frame_2 POSC.FRAME_TYPE, frame_3 POSC.FRAME_TYPE, frame_4 POSC.FRAME_TYPE, frame_5 POSC.FRAME_TYPE, frame_6 POSC.FRAME_TYPE, frame_7 POSC.FRAME_TYPE, frame_8 POSC.FRAME_TYPE, frame_9 POSC.FRAME_TYPE, frame_10 POSC.FRAME_TYPE, frame_11 POSC.FRAME_TYPE, frame_12 POSC.FRAME_TYPE, frame_13 POSC.FRAME_TYPE, frame_14 POSC.FRAME_TYPE, frame_15 POSC.FRAME_TYPE, frame_16 POSC.FRAME_TYPE, frame_17 POSC.FRAME_TYPE, frame_18 POSC.FRAME_TYPE, frame_19 POSC.FRAME_TYPE, frame_20 POSC.FRAME_TYPE, frame_21 POSC.FRAME_TYPE, frame_22 POSC.FRAME_TYPE, frame_23 POSC.FRAME_TYPE, frame_24 POSC.FRAME_TYPE, frame_25 POSC.FRAME_TYPE, frame_26 POSC.FRAME_TYPE, frame_27 POSC.FRAME_TYPE, frame_28 POSC.FRAME_TYPE, frame_29 POSC.FRAME_TYPE, frame_30 POSC.FRAME_TYPE, frame_31 POSC.FRAME_TYPE, frame_32 POSC.FRAME_TYPE, frame_33 POSC.FRAME_TYPE, frame_34 POSC.FRAME_TYPE, frame_35 POSC.FRAME_TYPE, frame_36 POSC.FRAME_TYPE, frame_37 POSC.FRAME_TYPE, frame_38 POSC.FRAME_TYPE, frame_39 POSC.FRAME_TYPE, frame_40 POSC.FRAME_TYPE, frame_41 POSC.FRAME_TYPE, frame_42 POSC.FRAME_TYPE, frame_43 POSC.FRAME_TYPE, frame_44 POSC.FRAME_TYPE) nested table frame_0.frame_axes store as ntmp_43298640_frame_0 return as value, nested table frame_1.frame_axes store as ntmp_40211432E7_frame_1 return as value, nested table frame_2.frame_axes store as ntmp_47647356E7_frame_2 return as value, nested table frame_3.frame_axes store as ntmp_74204642E7_frame_3 return as value, nested table frame_4.frame_axes store as ntmp_12921905E7_frame_4 return as value, nested table frame_5.frame_axes store as ntmp_65927756E7_frame_5 return as value, nested table frame_6.frame_axes store as ntmp_96622630_frame_6 return as value, nested table frame_7.frame_axes store as ntmp_15743260_frame_7 return as value, nested table frame_8.frame_axes store as ntmp_70251694E7_frame_8 return as value, nested table frame_9.frame_axes store as ntmp_93970008E7_frame_9 return as value, nested table frame_10.frame_axes store as ntmp_30876213E7_frame_10 return as value, nested table frame_11.frame_axes store as ntmp_37952650_frame_11 return as value, nested table frame_12.frame_axes store as ntmp_7340536E7_frame_12 return as value, nested table frame_13.frame_axes store as ntmp_86538130_frame_13 return as value, nested table frame_14.frame_axes store as ntmp_60594345E7_frame_14 return as value, nested table frame_15.frame_axes store as ntmp_33037512E7_frame_15 return as value, nested table frame_16.frame_axes store as ntmp_94657533E7_frame_16 return as value, nested table frame_17.frame_axes store as ntmp_7222471E7_frame_17 return as value, nested table frame_18.frame_axes store as ntmp_92868271E7_frame_18 return as value, nested table frame_19.frame_axes store as ntmp_50787974E7_frame_19 return as value, nested table frame_20.frame_axes store as ntmp_31591957E7_frame_20 return as value, nested table frame_21.frame_axes store as ntmp_65057629E7_frame_21 return as value, nested table frame_22.frame_axes store as ntmp_1684296E7_frame_22 return as value, nested table frame_23.frame_axes store as ntmp_71030736E7_frame_23 return as value, nested table frame_24.frame_axes store as ntmp_14192880_frame_24 return as value, nested table frame_25.frame_axes store as ntmp_11335429E7_frame_25 return as value, nested table frame_26.frame_axes store as ntmp_68821846E7_frame_26 return as value, nested table frame_27.frame_axes store as ntmp_82523701E7_frame_27 return as value, nested table frame_28.frame_axes store as ntmp_26980476E7_frame_28 return as value, nested table frame_29.frame_axes store as ntmp_46801359E7_frame_29 return as value, nested table frame_30.frame_axes store as ntmp_11321785E7_frame_30 return as value, nested table frame_31.frame_axes store as ntmp_9900273E7_frame_31 return as value, nested table frame_32.frame_axes store as ntmp_49521775E7_frame_32 return as value, nested table frame_33.frame_axes store as ntmp_32934192E7_frame_33 return as value, nested table frame_34.frame_axes store as ntmp_2854961E7_frame_34 return as value, nested table frame_35.frame_axes store as ntmp_72960857E7_frame_35 return as value, nested table frame_36.frame_axes store as ntmp_6905013E7_frame_36 return as value, nested table frame_37.frame_axes store as ntmp_72773688E7_frame_37 return as value, nested table frame_38.frame_axes store as ntmp_20017219E7_frame_38 return as value, nested table frame_39.frame_axes store as ntmp_48591566E7_frame_39 return as value, nested table frame_40.frame_axes store as ntmp_56925269E7_frame_40 return as value, nested table frame_41.frame_axes store as ntmp_37627959E7_frame_41 return as value, nested table frame_42.frame_axes store as ntmp_94422248E7_frame_42 return as value, nested table frame_43.frame_axes store as ntmp_2255154E7_frame_43 return as value, nested table frame_44.frame_axes store as ntmp_73175740_frame_44 return as value
Dependencies:
create or replace type posc.frame_type as object
(
cord_sys_sk VARCHAR2(18 CHAR),
grid_nm VARCHAR2(40 CHAR),
f_type NUMBER,
e_type NUMBER,
highest_ordinal NUMBER,
frame_axes frame_axes_type
)
create or replace type posc.frame_axis_type as object
(
property_type_name VARCHAR2(40 CHAR),
units_of_measure VARCHAR2(12 CHAR),
a_type NUMBER,
blob_contents BLOB
)
create or replace type posc.frame_axes_type as table of frame_axis_type