#26738 [Opn->Fbk]: PHP-OCI binding error
| From: | sniper@php.net | Date: | Fri, 02 Jan 2004 16:00:55 +0000 |
| Subject: | #26738 [Opn->Fbk]: PHP-OCI binding error | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-52719@lists.php.net to get a copy of this message | ||
ID: 26738
Updated by: sniper@php.net
Reported By: mbaranidharan at yahoo dot com
-Status: Open
+Status: Feedback
Bug Type: OCI8 related
Operating System: windows/linux
PHP Version: 4.3.4
New Comment:
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php
If you can provide more information, feel free to add it
to this bug and change the status back to "Open".
Thank you for your interest in PHP.
Previous Comments:
------------------------------------------------------------------------
[2003-12-29 04:56:56] mbaranidharan at yahoo dot com
Description:
------------
Trying to call a package in oracle which will return a parameter of
type table. When i try calling the procedure from PHP using OCI iam
getting wrong types or parameters.
Reproduce code:
---------------
$sql="declare var1 xxx.tbl_date;var2 xxx.tbl_varchar;";
$sql=$sql."begin xxx(3,:var1,:var2,:var3);end;";
$conn = OCILogon("usr","pwd","servername");
$stmt = OCIParse($conn,$sql);
OCIBindByname($stmt,'var1',$var1);
OCIBindByname($stmt,'var2',$var2);
OCIBindByname($stmt,'var3',$var3);
$rs = OCIExecute($stmt);
Expected result:
----------------
The result should be stored in the recordset which later can be
iterated and get the values from each array variable var1,2 and 3.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=26738&edit=1