Re: Passing a table or cursor into a stored procedure

hkvats_1999_at_yahoo.com
Date: 08/25/04 

Date: 25 Aug 2004 00:13:29 -0700

Hi Ferrill,

Cursor can be used as OUTPUT parameter only not as Input-Output. This
cursor will alow stored procedure to return a cursor as output.

Regards
Hari Sharma

"Russ Ferrill" <rferrill@paracominc.com> wrote in message news:<njJWc.12830$wN.2627@newssvr22.news.prodigy.com>...
> Thanks for the info. If I pass a cursor as an OUTPUT parameter, can I pass
> an actual cursor already declared with a select for loading the rows and
> then fetch those rows from within the stored procedure or is the cursor I am
> passing simply a means of allowing the stored procedure to return a cursor
> as output? Thanks again for any suggestions you may have.
>
>
> <hkvats_1999@yahoo.com> wrote in message
> news:68c8c86d.0408232133.7ef7b3e@posting.google.com...
> > Hi Ferrill,
> >
> > you can pass all data types, including text, ntext and image, as a
> > parameter to a stored procedure. However, the cursor data type can be
> > used only on OUTPUT parameters.
> >
> > Regards
> > Hari Sharma
> >
> > "Russ Ferrill" <rferrill@paracominc.com> wrote in message
> news:<xosWc.4753$gx7.2216@newssvr23.news.prodigy.com>...
> > > I have a stored procedure that I would like to be able to pass a table
> or
> > > cursor into so that it will process whatever records are contained in
> the
> > > input data. Is there any way to do this in T-SQL? If not, can somebody
> > > suggest a good workaround? Thanks very much in advance.

Relevant Pages

  • Re: How to use CURSOR with SELECT * ?
    ... It's described in the article about DECLARE CURSOR. ... Specifies that the scope of the cursor is local to the batch, ... An OUTPUT parameter is used to pass the local ... cursor back to the calling batch, stored procedure, or trigger, which can ...
    (microsoft.public.sqlserver.programming)
  • Re: aout cursor staoed procedure and vb6 (ado)
    ... I correct stored procedure name of prefix ... cursor on runing row by row. ... > 2) The RETURN value is not an OUTPUT parameter. ... >> DECLARE curBsDetail CURSOR FOR ...
    (microsoft.public.data.ado)
  • Re: Passing a table or cursor into a stored procedure
    ... If I pass a cursor as an OUTPUT parameter, ... then fetch those rows from within the stored procedure or is the cursor I am ... > you can pass all data types, including text, ntext and image, as a ...
    (microsoft.public.sqlserver.programming)
  • Re: Passing a table or cursor into a stored procedure
    ... If I pass a cursor as an OUTPUT parameter, ... then fetch those rows from within the stored procedure or is the cursor I am ... > you can pass all data types, including text, ntext and image, as a ...
    (microsoft.public.sqlserver)
  • Re: Stored Procedure, Output Value with SELECT Statement
    ... you are best off with the Set NoCount On in your procedure. ... your output parameter will only be available to your client code ... after you have read all of the select cursor on your client connection. ... load the recordset into an array or something so that you can get to ...
    (microsoft.public.data.ado)