Hello Wadi,

Wednesday, December 30, 2009, 2:24:31 PM, you wrote:

terima kasih banyak pak, udah sukses

  
> 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



-- 
Best regards,
fansul
mailto:[email protected]

__________________________________________________
Apakah Anda Yahoo!?
Lelah menerima spam?  Surat Yahoo! memiliki perlindungan terbaik terhadap spam  
http://id.mail.yahoo.com 

Kirim email ke