Re: How to write a SELECT stored procedure ?

From: Leon Lien <leonlien_at_earthlink.net>
Date: Fri, 13 Aug 99 03:25:14 GMT
Message-ID: <7p03f4$e1$1@fir.prod.itd.earthlink.net>

You have to use OO4O to retrive recordset from Oracle Store Procedure.

There is no way for VB ADO to get Oracle ADO recordset directly from Oracle Store Procedure, at least at the current time.

Also, write a Oracle Package to hold your Oracle Store Procedures might be needed.
Because you need to declare a Cursor type before you really start coding your
Oracle Store Procedure to make it return a cursor.

OO4O is Oracle Object for OLE, Oracle design this for VB, you can get it from Oracle
WEB site. They have different version for different Oracle Client. Watch out for this....

Also, I've encountered serious memory leak problem with OO4O now. Not trying to scare you, because I already have several applications written with OO4O
running quite successfully.

The recordset return by OO4O is called OraDynaset.... similiar to ADO recordset. Received on Thu Aug 12 1999 - 22:25:14 CDT