Re: stored procedures

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 11 Nov 1999 08:04:05 -0500
Message-ID: <lL4qOHL3YhgQyO9TFp1Gg8lvl89D@4ax.com>

A copy of this was sent to "Larry Pettit" <larry.pettit_at_ps.net> (if that email address didn't require changing) On Wed, 10 Nov 1999 14:56:18 -0700, you wrote:

>If a store procedure returns only one row, I use the
>select/into format, otherwise I use a cursor with a loop.
>
>Is there any other way to return multiple rows. We're using a visual c++
>client and it works with only one row but it's not working when the stored
>procedure (with a cursor) returns many.
>
>It works fine both ways in SQL *PLUS
>
>Any suggestions?
>Thanks.
>
>

Returing result sets is easy from a stored procedure -- you'll use a ref cursor (a cursor opened in the stored procedure, fetched from on the client).

See the url in my signature for examples in various programming languages.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Nov 11 1999 - 07:04:05 CST