2

I think, this is a problem with stored procedure +PDO beacause
when I make that:

$sql='SELECT * FROM table';
$db = Zend::registry('db');	
$stmt = $db -> prepare($sql);
$stmt -> execute();
$row = $stmt->fetch();
$stmt->closeCursor();
$stmt=null;

$sql='CALL porcedure_2(1)';
$stmt = $db -> prepare($sql);
$stmt -> execute();
$row = $stmt->fetch();
$stmt->closeCursor();
$stmt=null;

work everything 

when stored procedure is on first place - it doesn't work




ps - i apologize for my English

Solution

i maked a class

class connectDB
{
        private static $dbConn;
	
	private function __construct ()
	{}

        public static function setConnection ( )
	{
	   $config = Zend::registry('config');
   	   self::$dbConn = Zend_Db::factory($config->db->adapter, $config->db->config->asArray());
	   return self::$dbConn; 
	} 
}

and before executing a procedure i make new db connection

$db = connectDB::setConnection() ;

it's work


I know it is not fairest solution, but I don't find better solution

This bug has been fixed in CVS.

In case this was a documentation problem, the fix will show up at the
end of next Sunday (CET) on pecl.php.net.

In case this was a pecl.php.net website problem, the change will show
up on the website in short time.
 
Thank you for the report, and for helping us make PECL better.

Should be fixed with 5.3 when using mysqlnd (--with-pdo-mysql=mysqlnd or official PHP windows builds)