I have an Oracle 11g table with not null column and default value. Not null constraint is enabled, there are no triggers (in dba_triggers) which could to modify inserted value. It's impossible to insert null into this column by insert command from script, but thesame insert from package inserts default value in such case.
I can't find any help with Google. May be, someone knows what's the matter and how to correct it?
More info:
One of inserts(here're 3):
INSERT INTO ks_salda_kont
(id, ksk_id, instrument, numer_rejestru, saldo, obroty_d, obroty_k,
saldo_energii, obroty_energ_d, obroty_energ_k, udtczas_ks, udtczas_sys,
ksdo_id)
VALUES
(kssk_sq.nextval, iid, vInst, vRej, rr.kw_s, rr.kw_dt, rr.kw_kr, rr.en_s,
rr.en_dt, rr.en_kr, dData, dSys, iddo);
All variable names differ from column names. Erronous column is
numer_rejestru. Table creation statement is:
CREATE TABLE "PMSKS"."KS_SALDA_KONT"
( "ID" NUMBER(17,0) NOT NULL ENABLE,
"KSK_ID" NUMBER NOT NULL ENABLE,
"INSTRUMENT" VARCHAR2(130) DEFAULT 'XXX' NOT NULL ENABLE,
"NUMER_REJESTRU" VARCHAR2(100) DEFAULT 'XXX' NOT NULL ENABLE,
"SALDO" NUMBER(17,2) DEFAULT 0 NOT NULL ENABLE,
"OBROTY_D" NUMBER(17,2) DEFAULT 0 NOT NULL ENABLE,
"OBROTY_K" NUMBER(17,2) DEFAULT 0 NOT NULL ENABLE,
"OBROTY_ENERG_D" NUMBER(20,4) DEFAULT 0 NOT NULL ENABLE,
"OBROTY_ENERG_K" NUMBER(20,4) DEFAULT 0 NOT NULL ENABLE,
"SALDO_ENERGII" NUMBER(20,4) DEFAULT 0 NOT NULL ENABLE,
"BILANS_OTW_D" NUMBER(17,2) DEFAULT 0 NOT NULL ENABLE,
"BILANS_OTW_K" NUMBER(17,2) DEFAULT 0 NOT NULL ENABLE,
"UDTCZAS_KS" DATE DEFAULT to_date('19000101','yyyymmdd') NOT NULL ENABLE,
"UDTCZAS_SYS" DATE DEFAULT to_date('19000101','yyyymmdd') NOT NULL ENABLE,
"KSDO_ID" NUMBER DEFAULT 0 NOT NULL ENABLE,
CONSTRAINT "KSSK_KSSK_2_UK" UNIQUE ("KSK_ID", "INSTRUMENT", "NUMER_REJESTRU")