From: mbaranidharan at yahoo dot com Operating system: windows/linux PHP version: 4.3.4 PHP Bug Type: OCI8 related Bug description: PHP-OCI binding error
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 bug report at http://bugs.php.net/?id=26738&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=26738&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=26738&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=26738&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=26738&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=26738&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=26738&r=needscript Try newer version: http://bugs.php.net/fix.php?id=26738&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=26738&r=support Expected behavior: http://bugs.php.net/fix.php?id=26738&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=26738&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=26738&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=26738&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=26738&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=26738&r=dst IIS Stability: http://bugs.php.net/fix.php?id=26738&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=26738&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=26738&r=float