#37399 [Com]: Stored Procedure with more than one Resultset
ID: 37399
Comment by: jplock at gmail dot com
Reported By: aranna at free dot fr
Status: Assigned
Bug Type: Sybase-ct (ctlib) related
Operating System: REH3
PHP Version: 5.1.4
Assigned To: fmk
New Comment:
In my case, this is happening with mssql compiled to FreeTDS as well.
Previous Comments:
------------------------------------------------------------------------
[2006-05-16 09:15:51] aranna at free dot fr
Note this is Sybase not Mssql
------------------------------------------------------------------------
[2006-05-16 06:29:49] tony2001@php.net
Assigned to the maintainer.
------------------------------------------------------------------------
[2006-05-16 03:00:42] jplock at gmail dot com
Ok, more testing, after reverting to PHP 5.1.2 version of ext/mssql
(still using PHP 5.1.4), our stored procedure calls work properly
again. Something with those dbcancel() calls messes up
mssql_next_result(), unfortunately.
------------------------------------------------------------------------
[2006-05-16 02:54:14] jplock at gmail dot com
http://cvs.php.net/viewcvs.cgi/php-src/ext/mssql/php_mssql.c?r1=1.152.2.12&r2=1.152.2.13&pathrev=PHP_5_1
In between those differences, a dbcancel(mssql_ptr->link); was added on
line 1237 of php_mssql.c. In my case, we're executing a stored procedure
which returns five different result sets. One of those result sets calls
another stored procedure, which is failing because we're passing in a
null value (its suppose to be a real value from the first stored
procedure call), and is generate a "query failed" error. Could that 2nd
"query failed" error be terminating the link and all of the previous
result sets?
------------------------------------------------------------------------
[2006-05-16 01:13:13] jplock at gmail dot com
This used to work for us using FreeTDS 0.63 on Solaris 9 with PHP
5.1.2, but after upgrading to PHP 5.1.4, we can not retrieve multiple
result sets back using mssql_next_result(), it always returns false.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/37399
--
Edit this bug report at http://bugs.php.net/?id=37399&edit=1
Thread (9 messages)