ID: 26738 Updated by: [EMAIL PROTECTED] 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