ups comma yang pertama setelah using tidak terpakai, dihapus aja. Cheers, Wadi Achmed
2009/12/30 Wadi Achmed <[email protected]> > Kalo begitu coba cara ini > > vsql := 'BEGIN '|| > ' insert_stock_keluar@'||vdblink_dari|| > ' ( '|| > > ' vcd_comp => trim(:2), ' || > ' vnomor => trim(:3), ' || > ' vcd_barang => trim(:4), ' || > ' vqty => nvl(:5,0) ' || > ' ); '|| > 'END;'; > > execute immediate vsql using , > > :new.cd_comp, > :new.nomor, > :new.cd_barang, > :new.qty ; > > > Cheers, > Wadi Achmed > > 2009/12/30 <[email protected]> > > Hello fansul, >> >> Wednesday, December 30, 2009, 1:33:25 PM, you wrote: >> >> yang error di parameter :1 pak, klu saya tes nggak pakai dblink sukses >> aja. >> mohon solusinya lagi >> tks >> >> >> > Hello Wadi, >> >> > Wednesday, December 30, 2009, 11:14:49 AM, you wrote: >> >> > benar pak, script ada di dalam trigger. >> >> > masih error pak >> > ORA-01006: bind variable does not exist >> >> > parameter nya sampai 11 boleh nggak ya, dari :1 s/d :11 >> >> >> Helo Fansul, >> >> >> Script ini ada di dalam trigger ya? >> >> >> Bisa dengan cara seperti ini. >> >> >> vsql := 'BEGIN '|| >> >> ' insert_stock_keluar@":1"'|| >> >> ' ( '|| >> >> ' vcd_comp => trim(:2), ' || >> >> ' vnomor => trim(:3), ' || >> >> ' vcd_barang => trim(:4), ' || >> >> ' vqty => nvl(:5,0) ' || >> >> ' ); '|| >> >> 'END;'; >> >> >> execute immediate vsql using vdblink_dari, >> >> :new.cd_comp, >> >> :new.nomor, >> >> :new.cd_barang, >> >> :new.qty ; >> >> >> Kalo masih error, copy aja error messagenya yang lengkap di reply-nya >> >> >> Cheers, >> >> Wadi Achmed >> >> >> >> -- >> Best regards, >> fansul >> mailto:[email protected] >> >> __________________________________________________ >> Apakah Anda Yahoo!? >> Lelah menerima spam? Surat Yahoo! memiliki perlindungan terbaik terhadap >> spam >> http://id.mail.yahoo.com >> >> >> >> ------------------------------------ >> >> -- >> -----------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 >> >> >> >> > [Non-text portions of this message have been removed]
