#42076 [Com]: PDO_ODBC: Return parameters of stored procedure
| From: | aballard at gmail dot com | Date: | Wed, 01 Aug 2007 12:55:53 +0000 |
| Subject: | #42076 [Com]: PDO_ODBC: Return parameters of stored procedure | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-115647@lists.php.net to get a copy of this message | ||
ID: 42076
Comment by: aballard at gmail dot com
Reported By: ydiazc at gmail dot com
Status: Open
Bug Type: PDO related
Operating System: WINDOW XP
PHP Version: 5.2.3
New Comment:
I have observed similar problems using stored procedures in SQL server
using the Microsoft SQL ODBC driver on both Windows XP
Previous Comments:
------------------------------------------------------------------------
[2007-07-23 07:26:06] ydiazc at gmail dot com
Description:
------------
On the stores procedures not returned parameter of output or input
output with php pdo and driver ODBC in both cases (sql server and
oracle), is idem for both databases
PDO('odbc:Driver={Microsoft ODBC for Oracle}...
PDO('odbc:Driver={SQL Native Client}...
the parameters of input or input output, They enter without problems
to
store procedure, But they do not go out with value MODIFY of
procedure.
help me !!!, I need to use multiple engines.
Thank you for his help
Reproduce code:
---------------
CREATE PROCEDURE "BDSALUD"."PARAM" (Nombre IN OUT VARCHAR2)
IS
BEGIN
INSERT INTO REGISTRY name,value)VALUES (Nombre,777);
Nombre:='RONI';
END;
$stmt = $db->prepare("CALL PARAM(:Nombre)");
$Nombre = 'hello';
$stmt->bindParam(':Nombre', $Nombre,
PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT, 4000);
$resultado= $stmt->execute();
echo "<p>resultado: ".$resultado;
echo "<p>Nombre: ".$Nombre;
Expected result:
----------------
resultado: 1
Nombre: RONI
Actual result:
--------------
resultado: 1
Nombre: hello
(THE INSERT WAS DONE, BUT NOT MODIFIED $Nombre)
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=42076&edit=1