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

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