Dear All, Saya punya problem dengan trigger database, saya buat locking transaction sperti berikut :
CREATE OR REPLACE TRIGGER LOCKING_PERIODE BEFORE INSERT OR UPDATE OR DELETE ON DAILY_TRANS REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW DECLARE VVALIDATE VARCHAR2(8); VDATE VARCHAR2(8); BEGIN SELECT TO_CHAR(SYSDATE,'MMYYYY') INTO VVALIDATE FROM DUAL; IF :NEW.TANGGAL < TO_DATE(VVALIDATE,'MMYYYY') OR :OLD.TANGGAL < TO_DATE(VVALIDATE,'MMYYYY') THEN RAISE_APPLICATION_ERROR (-20670, 'You Can Not Insert Updating Preview Month Record.'); END IF; END; Masalahnya adalah ketika user melakukan transaksi pada form, database melakukan blocking trnsaksi baik insert/update/delete, tetapi pada form muncul message error :" FRM-40508 : oracle error : unable to insert record." ini disebabkan form tidak dapat inser karena trigger. tetapi kadang form mengeluarkan error "FRM-40655: SQL error forced rollback: clear form and re-enter transaction." dsn ketika saya clear record maka form bukan clearing record tetapi closing window System aplikasinya. Mohon bantuan solusi dr teman2... Mungkin ada yg pernah mengalami juga...? Thanks Regard's K.O -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
