Re: Calling stored Procs from VB

In article <1994Jul13.181529.25607_at_news.wrc.xerox.com> dmatt.henr801h_at_xerox.com writes:
>From: dmatt.henr801h_at_xerox.com
>Subject: Calling stored Procs from VB
>Date: Wed, 13 Jul 1994 21:25:16 GMT

>What is the syntax to execute an Oracle stroed proc from VB?
 

>ie. we have a stored proc named mrp.main in an ODBC data source.
 

>I want to execute this from a VB or VBA program with a call like
>db.executeSQL (mumble, DB_SQLPASSTHROUGH);
 

>What should replace mumble?
 

>Dave
>dmatt.henr801h_at_xerox.com

You can execute a stored procedure from VB by encapsulating it in a PL/SQL block.

dummy=db.executeSQL( " BEGIN mrp.main; END;")

The executeSQL command does not take DB_SQLPASSTHROUGH as this command is for use only with external databases.

Hope this helps,

Jim Lane
j.lane_at_bom.gov.au Received on Fri Jul 15 1994 - 10:01:29 CEST