Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ora-01401 error
I must be nuts. I can't find the column thats to long. Anyone see the
error here? The data column I have added to right of the desc for ease
of reading...
The long datatype column is null so it can't be converting any
characters in a wack fashion. There is a materialized view on this
table and I get the same error attempting to insert into it...
no triggers involved...
db version is oracle 8.1.7
SYSADM/CSAPHA>INSERT INTO ps_audit_employmnt
(AUDIT_OPRID,AUDIT_STAMP,AUDIT_ACTN,EMPLID,
2 EMPL_RCD_NBR,BENEFIT_RCD_NBR,HIRE_DT,REHIRE_DT,CMPNY_SENIORITY_DT,SERVICE_DT,
3 EXPECTED_RETURN_DT,TERMINATION_DT,LAST_DATE_WORKED,SUITABLE_FOR_REHIR,
4 OWN_5PERCENT_CO,REFERRAL_SOURCE,BUSINESS_TITLE,FT_STUDENT,SUPERVISOR_ID,
5 UNITED_WAY_AREACD,UNION_CD,BARG_UNIT,UNION_SENIORITY_DT,PROBATION_DT,
6 CREDIT_ASSOC_ID,SECURITY_CLEARANCE,WORK_PHONE,PROFILE_UPDATE_DT,
7 LAST_PROFILE_DT,TIME_RPT_LOC,JOB_REPORTING,DED_TAKEN,PAYCHECK_DIST_OPTN,
8 PAYCHECK_ADDR_OPTN,PAYCHECK_LOCN_OPTN,LOCATION,MAIL_DROP,PAYCHECK_NAME,
9 STREET1,STREET2,STREET3,CITY,COUNTRY,STATE,ZIP,BADGE_ID,CLASS_NAME,
10 CLOCK_ID,RESTRICTION_NAME,CUSTOM_AREA1,CUSTOM_AREA2,CUSTOM_AREA3,
11 CUSTOM_AREA4,DATE_A,DATE_B,DATE_C,DATE_D,FLAG_1,FLAG_2,FLAG_3,FLAG_4, 12 FLAG_5,FLAG_6,FLAG_7,MAPPER_ZEROS,USER_FIELD_1,USER_FIELD_2,LABOR_ACCOUNT, 13 ACQUISITION_DT,ELIGIBLE_FOR_SEVER,RESIGN_NOTICE_DT,RETIRE_DT,COMMENTS) 14 VALUES ('ADIJON',SYSDATE,'A','3716',0,0,TO_DATE('26-SEP-03','DD-MON-YY'), 15 NULL,TO_DATE('26-SEP-03','DD-MON-YY'),TO_DATE('26-SEP-03','DD-MON-YY'), 16 NULL,NULL,NULL,'Y','N',' ',' ','N',' ',' ',' ',' ',NULL,NULL,'',' ',' ',NULL,
SYSADM/CSAPHA>DESC ps_audit_employmnt
Name Null? Type DATA ------------------------------- -------- ---- AUDIT_OPRID NOT NULL VARCHAR2(8) 'ADIJON' AUDIT_STAMP DATE SYSDATE AUDIT_ACTN NOT NULL VARCHAR2(1) 'A' EMPLID NOT NULL VARCHAR2(11) '3716' EMPL_RCD_NBR NOT NULL NUMBER(4) 0 BENEFIT_RCD_NBR NOT NULL NUMBER(4) 0 HIRE_DT DATE TO_DATE('26-SEP-03','DD-MON-YY') REHIRE_DT DATE NULL CMPNY_SENIORITY_DT DATE TO_DATE('26-SEP-03','DD-MON-YY') SERVICE_DT DATE TO_DATE('26-SEP-03','DD-MON-YY') EXPECTED_RETURN_DT DATE NULL TERMINATION_DT DATE NULL LAST_DATE_WORKED DATE NULL SUITABLE_FOR_REHIR NOT NULL VARCHAR2(1) 'Y' OWN_5PERCENT_CO NOT NULL VARCHAR2(1) 'N' REFERRAL_SOURCE NOT NULL VARCHAR2(2) ' ' BUSINESS_TITLE NOT NULL VARCHAR2(30) ' ' FT_STUDENT NOT NULL VARCHAR2(1) 'N' SUPERVISOR_ID NOT NULL VARCHAR2(11) ' ' UNITED_WAY_AREACD NOT NULL VARCHAR2(2) ' ' UNION_CD NOT NULL VARCHAR2(4) ' ' BARG_UNIT NOT NULL VARCHAR2(1) ' ' UNION_SENIORITY_DT DATE NULL PROBATION_DT DATE NULL CREDIT_ASSOC_ID NOT NULL VARCHAR2(10) ' ' SECURITY_CLEARANCE NOT NULL VARCHAR2(1) ' ' WORK_PHONE NOT NULL VARCHAR2(15) ' ' PROFILE_UPDATE_DT DATE NULL LAST_PROFILE_DT DATE NULL TIME_RPT_LOC NOT NULL VARCHAR2(6) ' ' JOB_REPORTING NOT NULL VARCHAR2(1) 'N' DED_TAKEN NOT NULL VARCHAR2(1) 'D' PAYCHECK_DIST_OPTN NOT NULL VARCHAR2(1) 'I ' PAYCHECK_ADDR_OPTN NOT NULL VARCHAR2(1) 'H' PAYCHECK_LOCN_OPTN NOT NULL VARCHAR2(1) 'D' LOCATION NOT NULL VARCHAR2(5) ' ' MAIL_DROP NOT NULL VARCHAR2(50) ' ' PAYCHECK_NAME NOT NULL VARCHAR2(40) ' ' STREET1 NOT NULL VARCHAR2(40) '5sdfa' STREET2 NOT NULL VARCHAR2(40) ' ' STREET3 NOT NULL VARCHAR2(40) ' ' CITY NOT NULL VARCHAR2(30) 'sadf' COUNTRY NOT NULL VARCHAR2(3) 'USA' STATE NOT NULL VARCHAR2(2) 'CO' ZIP NOT NULL VARCHAR2(10) '23452' BADGE_ID NOT NULL VARCHAR2(10) ' ' CLASS_NAME NOT NULL VARCHAR2(15) ' ' CLOCK_ID NOT NULL VARCHAR2(15) ' ' RESTRICTION_NAME NOT NULL VARCHAR2(15) ' ' CUSTOM_AREA1 NOT NULL VARCHAR2(10) ' ' CUSTOM_AREA2 NOT NULL VARCHAR2(10) ' ' CUSTOM_AREA3 NOT NULL VARCHAR2(10) ' ' CUSTOM_AREA4 NOT NULL VARCHAR2(10) ' ' DATE_A DATE NULL DATE_B DATE NULL DATE_C DATE NULL DATE_D DATE NULL FLAG_1 NOT NULL VARCHAR2(1) ' ' FLAG_2 NOT NULL VARCHAR2(1) ' ' FLAG_3 NOT NULL VARCHAR2(1) ' ' FLAG_4 NOT NULL VARCHAR2(1) ' ' FLAG_5 NOT NULL VARCHAR2(1) 'N' FLAG_6 NOT NULL VARCHAR2(1) ' ' FLAG_7 NOT NULL VARCHAR2(1) ' ' MAPPER_ZEROS NOT NULL VARCHAR2(10) '0000000000' USER_FIELD_1 NOT NULL VARCHAR2(15) ' ' USER_FIELD_2 NOT NULL VARCHAR2(15) ' ' LABOR_ACCOUNT NOT NULL VARCHAR2(20) ' ' ACQUISITION_DT DATE NULL ELIGIBLE_FOR_SEVER NOT NULL VARCHAR2(1) 'N' RESIGN_NOTICE_DT DATE NULL RETIRE_DT DATE NULL COMMENTS LONG NULLReceived on Tue Sep 30 2003 - 08:38:30 CDT