ID: 26738 Updated by: [EMAIL PROTECTED] Reported By: mbaranidharan at yahoo dot com Status: Open Bug Type: OCI8 related Operating System: * PHP Version: 4.3.4 New Comment:
Can you tell us what error exactly do you get? Are there any error messages? Currently I can't understand what are you talking about, sorry. Previous Comments: ------------------------------------------------------------------------ [2004-01-04 23:21:17] mbaranidharan at yahoo dot com 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. ------------------------------------------------------------------------ [2004-01-02 11:00:55] [EMAIL PROTECTED] 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