Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Stored Procedure Question

Re: Stored Procedure Question

From: <owais_anjum_at_my-deja.com>
Date: 1999/09/22
Message-ID: <7s9q81$kcb$1@nnrp1.deja.com>#1/1

In article <7s8a66$ilp$1_at_morgoth.sfu.ca>,   Shantanu Sadanand Rangnekar <rangneka_at_sfu.ca> wrote:
> I was wondering if there is any way to create a stored procedure that
 has
> a result set without creating a cursor. Basically, I want to know if
 a
> cursor has to be created in order to return a result set in a stored
> procedure.
>
> Thanks in advance,
>
> Shantanu
>

yes, thats true. as far as i know, you need to make a cursor if you want to return resultset from an SP.
Owais

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 22 1999 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US