You can call stored procedure just like any other statement.  Here's a
snipplet:

     $sth = $dbh->prepare( 'call myproc(?)' );
     $sth->execute( 'parm1' );

     while( @row = $sth->fetchrow_array )
     {
          # do something
     }

Regards,
Michael


David Shrewsbury <[EMAIL PROTECTED]> on 01/11/2002 03:52:44 PM

To:   [EMAIL PROTECTED]
cc:
Subject:  DB2 stored procedures and result sets



Hello gang,

Being rather new to stored procedures, can someone tell
me if it is possible to call a DB2 procedure that
generates a result set and then after the procedure call,
somehow retrieve the rows of the result one at a time via
the DBI interface? Can someone provide some sample DBI code
to show me the basics (if this is even possible)?

TIA,
-Dave





Reply via email to