ага, забил нулями.
ALTER TRIGGER SUPERMAG.SMCARDPROPSCHECKROLE DISABLE;
ALTER trigger supermag.smstoreunitsiu disable;
INSERT into supermag.smcard (article, globalarticle, arrivedfrom, bornin,
name, shortname, idmeasurement, idclass, idscale, subarticle, accepted,
datatype, datasubtype, scaleload, cashload, receiptok, storage, deadline,
losses, scrap, waste, mesname, mesabbrev, country, cardcomment, flags,
cutpricedays, supplypricepercentp, supplypricepercentm, minprofit,
idthreetorg, idonetorg)
VALUES(004111,004111,NULL,'0','Тест1','Тест1',0,4,NULL,NULL,0,0,-1,0,1,1,0,NULL,0,0,0,'штука','шт','','',0,0,NULL,NULL,0,NULL,NULL);
Это отработало, добавили строчку и smcard
теперь следующее:
INSERT into supermag.smstoreunits(barcode, barcodetype, unitname, article,
quantity, facequantity, flags, subarticle, nestedbar, weight, tareweight,
tarewidth, tarelength, tareheight, maxy)
VALUES('4606782040577',1,'øò','004111',1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
и вот тут ошибка:
ORA-01403: данных не найдено
ORA-06512: на "SUPERMAG.CARDS", line 3086
ORA-06512: на "SUPERMAG.SMSTOREUNITSDERIVEDFACEQ", line 2
ORA-04088: ошибка во время выполнения триггера 'SUPERMAG.SMSTOREUNITSDERIVEDFACEQ'