Re: Getting array of rows from PL/SQL

From: Bjorn Borud <borud_at_guardian.no>
Date: 1998/07/03
Message-ID: <m2ogv7nzrb.fsf@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 Gilmore

Received on Fri Jul 03 1998 - 00:00:00 CDT