Re: Calling stored Procs from VB

In article <1994Jul13.181529.25607_at_news.wrc.xerox.com>

           dmatt.henr801h_at_xerox.com writes:

> 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
>

Send your command as an anonymous PL/SQL block thus:

 db.executeSQL ("begin mrp.main; end;", DB_SQLPASSTHROUGH);

-- 
Stephen Lappin

+-----------------+
| +-------------+ |  Real Time Engineering Ltd.
| |  Real Time  | |  Capital House
| +-------------+ |  20 Park Circus
| Engineering Ltd |  Glasgow G3 6BE         Tel: +44 (0)41 332 9400
+-----------------+  Scotland U.K.          Fax: +44 (0)41 331 2509