RE: [PHP-WIN] SQL Server stored procedures and functions
| From: | Paco Ortiz | Date: | Wed, 23 May 2001 12:04:37 +0000 |
| Subject: | RE: [PHP-WIN] SQL Server stored procedures and functions | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-7869@lists.php.net to get a copy of this message | ||
Hi,
>Two problems with stored procedures, no return value and no output
>parameters. You'll need to reformat all your procedures to have a SELECT
>statement return those values.
>
>I've been told that the 4.0.6 (as of yet unreleased) version has better
>support for stored procedures. You might want to grab it from CVS and
>compile before you go and modify a bunch of stuff on the SQL server.
I submitted some time ago a patch to enable OUTPUT parameters and return
values under MSSQL, using three new API calls à-la OCI8 (init statement, bind parameters, execute)
.
It doesn't seem to be included in the latest CVS yet.
It has been working fine for us for the last 4 months, so if someone out there needs it badly...
Greetings
Paco