Re: Calling an external procedure from a stored procedure

External procedures are dll's on NT (either single process or multi threaded in 8.0.4+ via the external agent) if they are able to access COM objects standalone then they should work, but VB requires vbrunxx.dll and this can not be included. In 8.1 you will be able to calls from PL/SQL directly to COM objects via the COM cartridge.

Rgards
David Russell

Abeeda_Mohammed_at_xn.xerox.com wrote in message <6n06se$phk$1_at_nnrp1.dejanews.com>...
>Hello,
>
>Oracle 8.03
>VB 5.0
>RUMBA OCX
>PL?SQL 8.03
>
>The system which we are working on is being migrated from a legacy system.
To
>keep the legacy system in sync with the new system so that, the developer
is
>going to use RUMBA OCX and VB to feed in every transaction that takes place
>in the new system. i.e the stored procedure which updates the oracle tables
>should also call the external procedure to update the legacy system.
>
>Can I call an external procedure which is written in Vb? Please give an
>example.
>
>Thank you,
>
>Abeeda
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Sat Jun 27 1998 - 17:56:27 CDT