|   | php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login | 
| 
 PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits              [2006-10-15 18:11 UTC] wez@php.net
 | |||||||||||||||||||||||||||
|  Copyright © 2001-2025 The PHP Group All rights reserved. | Last updated: Fri Oct 31 12:00:01 2025 UTC | 
Description: ------------ If I try to open a 2nd statement handle against prepared statement on SQL 2000 and windows the 2nd attempt will fail. I can create a new object per statement and it is fine. The problem is only happening on prepared stored procedures. If I prepare a sql statement it seems fine. Reproduce code: --------------- $stmt = $dbh->prepare("exec pdo_test"); $stmt->execute(); echo $x . " " . var_dump($stmt->fetch()) . "<br>"; // $stmt = null; $stmt2 = $dbh->prepare("exec pdo_test"); $stmt2->execute(); echo $x . " " . var_dump($stmt2->fetch()) . "<br>"; Here is the sql to create SP: create procedure pdo_test as select 'Hello' msg Expected result: ---------------- Hoping both statements would print the array with Hello in it Actual result: -------------- The second result will print false. If I uncomment the $stmt = null; then everything works great.