#26738 [Fbk->Opn]: PHP-OCI binding error

ID: 26738 User updated by: mbaranidharan at yahoo dot com Reported By: mbaranidharan at yahoo dot com -Status: Feedback +Status: Open Bug Type: OCI8 related Operating System: windows/linux PHP Version: 4.3.4 New Comment: Iam trying to call a package in oracle 9i db which returns me out parameters of type table.When i try to bind the out parameter and execute iam getting error. This error occured bcoz table type in oracle again internally an array which php is not able to identify.I get the same error with both ORA and OCI. Previous Comments: ------------------------------------------------------------------------ [2004-01-02 11:00:55] sniper@php.net 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. ------------------------------------------------------------------------ [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