Getting stored procedures result codes with ODBC
| From: | Santiago Holgado | Date: | Mon, 12 Jun 2000 09:09:45 +0000 |
| Subject: | Getting stored procedures result codes with ODBC | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-334@lists.php.net to get a copy of this message | ||
I'm trying to call stored procedures in MS SQL Server using ODBC to obtain a result code.
$Results = odbc_prepare($conn, "{CALL mysp(?, ?)}");
$param[0] = "data0";
$param[1] = "data1";
odbc_execute($Results, $param);
This works correctly, but if I try to do this
$Results = odbc_prepare($conn, "{? = CALL mysp(?, ?)}");
$param[1] = "data0";
$param[2] = "data1";
odbc_execute($Results, $param);
it produces a "Fatal: emalloc() unable to allocate 65536 bytes". The CALL sentence is
correct according to SQL Server documentation. Does anyone know a solution?