Walaupun masalah tgl_LHR solve, akan muncul error muttating triggers.
karena triggernya mengupdate table itu sendiri. (dalam hal ini table karywawan). yang perlu diperjelas lagi, sebetulnya trigger ini fungsinya untuk apa ? Regard's Agus ________________________________ From: juanda hakim <[email protected]> To: [email protected] Sent: Thu, 11 February, 2010 17:41:52 Subject: Bls: [indo-oracle] Mhn Koreksi Error Trigger Update tgl_LHR itu apa?? apakah tgl_lhr itu merupakan atribut?? ____________ _________ _________ __ Dari: Padang Nadimpu <nadi...@yahoo. com> Kepada: indo-oracle@ yahoogroups. com Terkirim: Kam, 11 Februari, 2010 17:31:03 Judul: [indo-oracle] Mhn Koreksi Error Trigger Update Master Oracle, mohon dikoreksi error trigger update : SQL> CREATE OR REPLACE TRIGGER ID_SEUMUR_HIDUP 2 AFTER UPDATE ON KARYAWAN FOR EACH ROW 3 DECLARE 4 BEGIN 5 IF FLOOR(MONTHS_ BETWEEN(sysdate, TGL_LHR)/ 12)>=60 6 AND TGL_CETAK_ID IS NOT NULL 7 THEN 8 UPDATE KARYAWAN 9 SET TGL_PJG_ID= TO_CHAR(TGL_ CETAK_ID, 'DD-MM-') ||'2050' WHERE NIK = :NEW.NIK; 10 END IF; 11 END; 12 / Warning: Trigger created with compilation errors. SQL> SQL> SQL> SHOW ERROR; Errors for TRIGGER ID_SEUMUR_HIDUP: LINE/COL ERROR -------- ------------ --------- --------- --------- --------- --------- - 3/4 PL/SQL: Statement ignored 3/36 PLS-00201: identifier 'TGL_LHR' must be declared SQL> Atas kesediaannya, diucapkan trims Apakah saya bisa menurunkan berat badan? Temukan jawabannya di Yahoo! Answers! http://id.answers. yahoo.com [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
