Re: Create ResultSet in Stored Procedure and give it back to a VB5 program. How to?

Oracle procedures can return a result set (though somewhat limited). Sylvain Faust Inc. markets a product called SQL-Sombrero OCX / OCI. This product gives VB programmers access to the Oracle Call Interface. Using this interface you can return result sets from stored procedures.

Check out the web site at http://www.sfi-software.com. Go to the download for an evaluation of the product.

Tomm Carr <tommcatt_at_geocities.com> wrote in article <33DD454D.255E_at_geocities.com>...
> Michael G. Schneider wrote:
> >
> > I use Oracle from VB5 by means of RDO. All works fine (executing a SQL,
> > calling a stored procedure, using arguments, ...) - with one exception.
> > Maybe somebody can help.
> >
> > I would like to create a resultset in a stored procedure and pass the
> > resultset back to an rdoResultset object. I just can't find a way to
> > achieve this.
>
> Oracle procedures cannot return a result set. However, starting with
> 7.2, you have cursor variables which give you pretty much the same
> thing. How (or *if*) they work with VB, though, I don't know. I yield
> the floor to anyone who knows VB....
>
> --
> Tomm Carr
> --
> "Can you describe your assailant?"
> "No problem, Officer. That's exactly what I was doing when he hit me!"
>
Received on Thu Jul 31 1997 - 00:00:00 CDT