Re: executing Oracle stored procedure from VB

Although I do not know the specific syntax for ODBC, the Oracle Objects for OLE syntax is as follows:

oradatabase.dbExecuteSQL ("Begin dbo.sp_CreateCall (:CallerID, :OwnerID); end;")

The contents in the quotes, "Begin dbo.sp_CreateCall (:CallerID, :OwnerID); end;" is the text passed to the Oracle for OLE control. The items :CallerID, and :OwnerID are stored procedure parameters which are BOUND to the OLE control before the stored procedure is called. Perhaps you have to define variables within the Begin . . . . end; block before you call the procedure ?

Feel free to contact me at jkrul_at_equist.com if you still cannot get it to work.

Jeff.
EQUIST Inc.
jkrul_at_equist.com

Daniel MARCOTTE <scorpion_at_marge.cs.mcgill.ca> wrote in article <55adu6$2ol_at_sifon.cc.mcgill.ca>...
> hello,
> I'm programming in Visual Basic 4.0/32-bit and I want
> to execute an Oracle stored procedure which does not return any
> value, anly delete records from a table stored in an Oracle server.
> I'm using an ODBC (Openlink) connection (RDO), and I can easily
> access all the tables..but I can't execute the procedure.
>
> what is the syntax??
> thank you for your help
>
> --
>
> ______ _ _ __
> // __ _//\ //\ //_/
> // / /_//\_\ //_/\ //_/ scorpion_at_cs.mcgill.ca
> // / /_//__\_\//_/|_\//_/ Daniel Marcotte
> // /__/_//----\_/_/ |_ _/
> //______// \_/ |_/ http://www.cs.mcgill.ca/~scorpion
>
>
>
Received on Tue Nov 05 1996 - 00:00:00 CST