Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: [Q] Multiple Rows ret. by StoredProc
On 30 Jul 1997 17:19:44 GMT, "Mike Lewis" <mike.lewis_at_lgeenergy.com> wrote:
>I do not believe so. We ran into the same problem trying to get stored
>procs to send multi-row result sets back to a Delphi program. Apparently,
>Oracle stored procs act like functions and return only a singleton result.
>We got around the problem by having the stored proc write the result set to
>a temporary table, and then within our Delphi code, we added a statement to
>query the database to read the temporary table. Hope this solution will
>work for you.
You can return result sets via a stored proc in Oracle 7.3 using cursor variables in Delphi. Received on Thu Jul 31 1997 - 00:00:00 CDT