Maaf, salah ketik.. s bukan :old:no_id; tapi :old.no_id;
Semua bisa dibaca di cd documentationnya. salam 2009/11/19 Padang Nadimpu <[email protected]> > > > Sesuai pencerahan yg diberikan, saya telah mengeksekusi script di bawah ini > : > > create or replace trigger penduduk > after delete on penduduk > for each row > begin > delete from domisili where no_id=:old:no_id; > end; > / > > kemudian tampil pesan : > > Warning: Trigger created with compilation errors > > Selanjutnya saya lihat triggernya lewat oracle enterprise manager console > Errornya sebagai berikut : > > Line # = 2 Column # = 39 Error Text = PLS-00049: bad bind variable 'OLD' > Line # = 2 Column # = 43 Error Text = PLS-00049: bad bind variable 'NO_ID' > > Mohon solusi pencerahan, apa yg mesti sy lakukan ? > > Best Regard's > > --- On Thu, 11/19/09, stanleycia > <[email protected]<stanleycia%40gmail.com>> > wrote: > > From: stanleycia <[email protected] <stanleycia%40gmail.com>> > Subject: Re: [indo-oracle] Hapus data pd 2 table scr bersama > To: [email protected] <indo-oracle%40yahoogroups.com> > Date: Thursday, November 19, 2009, 11:55 AM > > > > Salam kenal.. saya baru join.. > > coba bantu ya.. semua ada di documentationya :) > > create or replace trigger ... before delete on DOMISILI > > for each row > > begin > > delete from penduduk where no_id=:old:no_ id; > > end; > > dengan catatan penduduk tdk ada referential integrity ke domisili. lebih > > aman pake 2 statement delete saja. > > 2009/11/19 Anthony Kurniawan <anthony_kurniawan04 0...@yahoo. com> > > > > > > > > > Dear, > > > > > > klo pake trigger gmana cara taunya Pak yg didelete no_id nya yang mana ? > > > misal di domisili, saya delete no_id = 1212, > > > trus pasang triggernya kan di domisili, gmn caranya Pak biar kita tau > no_id > > > mana di table penduduk yang mau didelete ? dimasukkin variabel ? or gmn ? > > > thx... > > > > > > Hmm sebaiknya sih jika kondisi table seperti itu, dari tabel penduduk > untuk > > > field id, diberikan foreign key yang mengacu ke tabel domisili dan > > > ditambahkan fitur on delete cascade, sehingga apabila satu row dr suatu > id > > > tabel domisili tersebut dihapus maka di tabel penduduk row yang memiliki > id > > > tersebut akan terhapus juga... > > > > > > hope this help... > > > > > > "Gapailah cita-citamu setinggi langit karena jika kau meleset sekalipun, > > > kau akan tetap berada diantara bintang-bintang" > > > > > > --- Pada Kam, 19/11/09, Agus Haryanto <[email protected]<agus_h23%40yahoo. > > com>> > > > menulis: > > > > > > Dari: Agus Haryanto <agus_...@yahoo. com <agus_h23%40yahoo. com>> > > > Judul: Re: [indo-oracle] Hapus data pd 2 table scr bersama > > > Kepada: indo-oracle@ yahoogroups. com <indo-oracle% 40yahoogroups. com> > > > Tanggal: Kamis, 19 November, 2009, 3:57 AM > > > > > > > > > > > > Kalau Mau simple pakai Trigger aja pak > > > > > > Triggernya dipasang ditable domisili, > > > > > > ketika ada record ditable domisili didelete maka secara otomatis record > di > > > table penduduk juga didelete > > > > > > Regard's > > > > > > Agus > > > > > > ____________ _________ _________ __ > > > > > > From: Padang Nadimpu <nadi...@yahoo. com> > > > > > > To: indo-oracle@ yahoogroups. com > > > > > > Sent: Wed, 18 November, 2009 19:01:11 > > > > > > Subject: [indo-oracle] Hapus data pd 2 table scr bersama > > > > > > Ada 2 table, misalnya data domisili dan penduduk. > > > > > > Pada kedua table terdpt no_id yg sama. > > > > > > Sy coba script hapus seperti di bawah ini : > > > > > > SQL>DELETE from domisili x, penduduk y WHERE x.no_id=y.no_ id and > > > x.no_id=11107070001 ; > > > > > > DELETE from domisili x, from penduduk y WHERE x.no_id=y.no_ id and > > > x.no_id=11107070001 ; > > > > > > * > > > > > > ERROR at line 1: > > > > > > ORA-00933: SQL command not properly ended > > > > > > Mohon koreksi/solusi agar dpt menghapus data pada 2 table scr bersama > > > > > > Best Request > > > > > > [Non-text portions of this message have been removed] > > > > > > Yahoo! Mail Kini Lebih Cepat dan Lebih Bersih. Rasakan bedanya sekarang! > > > http://id.mail. yahoo.com > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> 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/
