tgl_LHR itu apa?? apakah tgl_lhr itu merupakan atribut??
________________________________ Dari: Padang Nadimpu <[email protected]> Kepada: [email protected] 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]
