Re: ORA-00439

More info about the table being inserted:

SQL> desc core.cz_aud

 Name                                      Null?    Type
 ----------------------------------------- -------- -----------------

 AUD_CHG_SIN                               NOT NULL NUMBER(10)
 AUD_MAINT_SIN                             NOT NULL NUMBER(10)
 AUD_OPER_ID                               NOT NULL CHAR(16)
 AUD_BU                                    NOT NULL NUMBER(6)
 AUD_PROD_SPROD_IND                        NOT NULL CHAR(2)
 AUD_ACTVTY_TS                             NOT NULL TIMESTAMP(6)
 AUD_UI_DESC                               NOT NULL VARCHAR2(50)

• unique index ----

CREATE UNIQUE INDEX "CORE"."AUDX1"
    ON "CORE"."CZ_AUD" ("AUD_CHG_SIN")
    TABLESPACE "CORE_I" PCTFREE 10 INITRANS 2 MAXTRANS 255     STORAGE ( INITIAL 4096K NEXT 4096K MINEXTENTS 1 MAXEXTENTS     2147483645 PCTINCREASE 0)
    LOGGING

• trigger -----

DECLARE
    INTEGRITY_ERROR EXCEPTION;

    ERRNO            INTEGER;
    ERRMSG           CHAR(200);
    DUMMY            INTEGER;
    FOUND            BOOLEAN;

BEGIN
    IF :NEW.AUD_CHG_SIN IS NULL THEN

• COLUMN "AUD_CHG_SIN" USES SEQUENCE CORE.S_CZ_AUD SELECT CORE.S_CZ_AUD.NEXTVAL INTO :NEW.AUD_CHG_SIN FROM DUAL; END IF;
  • ERRORS HANDLING EXCEPTION WHEN INTEGRITY_ERROR THEN RAISE_APPLICATION_ERROR(ERRNO, ERRMSG); END;