FAQ
Hi,

Can stored procedure return mutiple rows of a select statement ? In
another word, could I have collection or
varrys as out paramters ? If yes, is it recommended
to use stored procedure in this case or I should just use sql statements
?

Thanks in advance,

Jie

Search Discussions

  • Harrington Michael at Oct 8, 2001 at 9:41 pm
    Jie,

    Stored procedures can return multiple rows. Personally, I just step thru
    the array that fetch brings back to work with the rows. Works like a charm!
  • Harrington Michael at Oct 8, 2001 at 9:43 pm
    Jie,

    Stored procedures can return multiple rows. Personally, I just step thru
    the array that fetch brings back to work with the rows. Works like a charm!
    -----Original Message-----
    From: jie zhang [SMTP:jie@best.com]
    Sent: Monday, October 08, 2001 3:17 PM
    To: dbi-users@perl.org
    Subject: mutiple rows result from a stored procedure

    Hi,

    Can stored procedure return mutiple rows of a select statement ? In
    another word, could I have collection or
    varrys as out paramters ? If yes, is it recommended
    to use stored procedure in this case or I should just use sql statements
    ?

    Thanks in advance,

    Jie
  • Jie zhang at Oct 8, 2001 at 10:32 pm
    Hi, Harrington,

    Do you know if there is a limit of how many rows it could return ? I read
    somewhere that there is 64K limit
    on the in and out parameter ?

    Thanks a lot,

    Jie

    Harrington Michael wrote:
    Jie,

    Stored procedures can return multiple rows. Personally, I just step thru
    the array that fetch brings back to work with the rows. Works like a charm!
    -----Original Message-----
    From: jie zhang [SMTP:jie@best.com]
    Sent: Monday, October 08, 2001 3:17 PM
    To: dbi-users@perl.org
    Subject: mutiple rows result from a stored procedure

    Hi,

    Can stored procedure return mutiple rows of a select statement ? In
    another word, could I have collection or
    varrys as out paramters ? If yes, is it recommended
    to use stored procedure in this case or I should just use sql statements
    ?

    Thanks in advance,

    Jie
  • Harrington Michael at Oct 9, 2001 at 12:43 pm
    Jie,

    Since all you get back is a cursor (pointer), there is no limit on number
    of rows.

    As far as parameters :

    CLOBS and BLOBS are supported in V6 - whatever those limits are...beyond
    that I don't know of any beyond what the standard data types support.

    The number of parameters is limited by the maximum value of the ORDINAL
    column in SYSIBM.SYSPARMS (SMALLINT).

    Hope this helps.
    -----Original Message-----
    From: jie zhang [SMTP:jie@best.com]
    Sent: Monday, October 08, 2001 5:32 PM
    To: Harrington Michael
    Cc: dbi-users@perl.org
    Subject: Re: mutiple rows result from a stored procedure

    Hi, Harrington,

    Do you know if there is a limit of how many rows it could return ? I read
    somewhere that there is 64K limit
    on the in and out parameter ?

    Thanks a lot,

    Jie

    Harrington Michael wrote:
    Jie,

    Stored procedures can return multiple rows. Personally, I just step thru
    the array that fetch brings back to work with the rows. Works like a
    charm!
    -----Original Message-----
    From: jie zhang [SMTP:jie@best.com]
    Sent: Monday, October 08, 2001 3:17 PM
    To: dbi-users@perl.org
    Subject: mutiple rows result from a stored procedure

    Hi,

    Can stored procedure return mutiple rows of a select statement ? In
    another word, could I have collection or
    varrys as out paramters ? If yes, is it recommended
    to use stored procedure in this case or I should just use sql
    statements
    ?

    Thanks in advance,

    Jie

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdbi-users @
categoriesperl
postedOct 8, '01 at 8:18p
activeOct 9, '01 at 12:43p
posts5
users2
websitedbi.perl.org

2 users in discussion

Harrington Michael: 3 posts Jie zhang: 2 posts

People

Translate

site design / logo © 2022 Grokbase