Hello,
I have managed to execute MS SQL Server 7.0 stored procedures using DBD-ODBC like
this:
{call Proc_Name(?, ?......)}
However, I have only done it with procedures involving UPDATE, DELETE, or INSERT. I
want to write stored procedures that use SELECT.
First, can I retrieve rows with DBD-ODBC from a result set generated by a stored
procedure?
Second, is the return value of $dbh->do() always "1" when a stored procedure is called
with it using DBD-ODBC? It seems that that is the case when I use it to execute a
stored procedure even if the procedure updates multiple rows.
Third, is there another (and perhaps better) way to call stored procedures from
DBD-ODBC?
Thanks!
Configuration:
DBI 1.14
DBD-ODBC 0.28
ActivePerl 618
Windows 2000 Server
MS SQL Server 7.0
