Re: Getting array of rows from PL/SQL
From: Bjorn Borud <borud_at_guardian.no>
Date: 1998/07/03
Message-ID: <m2ogv7nzrb.fsf_at_lucifer.guardian.no>#1/1
| 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.
Date: 1998/07/03
Message-ID: <m2ogv7nzrb.fsf_at_lucifer.guardian.no>#1/1
[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 GilmoreReceived on Fri Jul 03 1998 - 00:00:00 CEST