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]
