Re: Calling Stored Procedures from VB.

With SQL-Sombrero for OCI you can do it easily. It is an OCX that exposes OCI. We provide samples on how to do this.

Look at: http://www.sfi-software.com/prod_SQLSomOCXOCI.htm

Collin Bath wrote in message <37EB3038.AB03944E_at_nt.com>...
>Can anyone use ORACLE stored procedures/packages to retrieve multiple
>rows from the database to the client using Visual Basic 6.0 ?
>
>Currently I am using ADO to call ORACLE v7.3.3 stored procedures that
>perform various insert/update transactions but would like to be able to
>encapsulate SQL in an ORACLE database and pass rows back to the client.
>
>There are two methods for passing rows between the client and server
>within ORACLE PL/SQL and I wonder if I can do the same using VB. Any
>method will do if not possible with ado, (oledb calls etc..)
>
>Option One
>Fetch all rows within the stored procedure and pass them back to Visual
>Basic as a PL/SQL table. This is Oracle's version of a single
>dimensioned array.
>
>Option Two
>Use what is known as a cursor variable in ORACLE. This stores the SQL in
>the database and passes a pointer to a cursor back to the client as a
>parameter. The client then fetches the rows using the cursor variable.
>
>Any help would be much appreciated.
>
>Thanks
>
>Collin Bath.
>cbath_at_nortelnetworks.com
Received on Fri Sep 24 1999 - 14:51:35 CDT