Re: Getting array of rows from PL/SQL (VB5 and RDO )

Bjorn Borud <borud_at_guardian.no> wrote in article <m2ogv7nzrb.fsf_at_lucifer.guardian.no>...
> [SqlEdi_at_mcs.net (James Febbo)]
> |
> | You can cause the stored procedure to be
> | executed from the client easily enough, right?
> | What's giving you trouble is getting back rows
> | from the stored procedure.
> |
> | Answer: don't try. The protocols aren't well
> | enough defined yet to do this! Instead, write
> | the procedure so it extracts what you want,
> | a batch at a time, and writes it to a temporary
> | table. Then just use you normal stuff from the
> | client to select from the temp table as you
> | wish.
>
> or he could do what a lot of application builder tools do: using a
> reference cursor to return rows of data.
>
> create a stored procedure that has an OUT argument which is the
> reference cursor. in your application, bind the argument to a cursor
> and execute the stored procedure. you can now fetch from the
> reference cursor.
>
> -Bjørn
> --
> Bjørn Borud <borud_at_guardian.no> | "The Net interprets censorship
> <URL:http://www.pvv.unit.no/~borud/> | as damage and routes around it."
> UNIX person, one of "them" | - John Gilmore
>

This sounds great, but how can you create a cusor in VB5 using rdo? Any help???

Thanks a lot

Ajay Received on Mon Jul 06 1998 - 00:00:00 CEST