|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Oracle Trigger Automatically Deleted
Hi all!
im just wondering why my trigger was automatically deleted.. is there anyone could help me. anyway, below is my script. CREATE OR REPLACE TRIGGER TRGR_DLY01_ELECTRA AFTER INSERT ON "DLY01" FOR EACH ROW begin insert into ELECTRA_BAL (ACCTNMBR,AVAIL_BAL,TRXMNCODE, TRXTYPE,DATEPOST,TIMETXN,SEQNMBR,TRANAMT,BRNCHNMBR,TELLERID) values(:NEW.ACCTNMBR,:NEW.AVAIL_BAL,:NEW.TRXMNCODE,:NEW.TRXTYPE, :NEW.DATEPOST,:NEW.TIMETXN,:NEW.SEQNMBR,:NEW.TRANAMT, :NEW.BRNCHNMBR,:NEW.TELLERID); delete from ELECTRA_BAL where trxmncode in ('ASW ','ASC '); delete from ELECTRA_BAL where acctnmbr not in (select acctnmbr from mstr01 where llnmbr = 1); update ELECTRA_BAL set status = 'N' where status is null; end; Thanks in advance! Cheers! |
|
#2
|
|||
|
|||
|
did that happen again or just once? dont think it would be anything to do with whats actually in the trigger.
|
|
#3
|
|||
|
|||
|
Quote:
yeah it did! that is why im trying to get any comment from this forum. actually after i created the trigger, i tried to shutdown the unix server just to simulate if the trigger will be deleted after the shutdown, but it does not. Thanks |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > Oracle Trigger Automatically Deleted |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|