From: lbouteille dot ext at francetelecom dot com Operating system: Win 2000 PHP version: 5.1.2 PHP Bug Type: OCI8 related Bug description: LOB Type mismach when using windows & oci8.dll
Description: ------------ I'm currently facing this problem with : - 1 production environnement (Unix,Oracle 9.2, Apache 2.046, Php 5.0.4) - 1 developpment env (Windows, Apache 2.046,Php 5.0.4 and using the production database) then trying to update an XML field of my database (see code) The only difference I found is : - production php is compiled --with-oci8 - dev php is using php_oci8.dll through php.ini I guess this is a problem with windows oci8.dll ? Reproduce code: --------------- $query = "UPDATE table SET table= updateXML(table,'/TABLE/DATA,xmltype.createXML(:data)) WHERE existsNode(projet,'/PROJET/[ID=$id]')=1"; $stmt = oci_parse ($_SESSION['conn'], $query); $clob = OCINewDescriptor($_SESSION['conn'], OCI_D_LOB); oci_bind_by_name($stmt, ':data', &$clob, -1,OCI_B_CLOB); $clob->WriteTemporary($xml,OCI_TEMP_CLOB); $success = OCIExecute($stmt,OCI_COMMIT_ON_SUCCESS); OCIFreeStatement($stmt); $clob->free(); Expected result: ---------------- This should be working fine, like on the production (unix) machine Actual result: -------------- It will say : ORA-24805 LOB Type mismatch (error at line OCIExecute(...)) -- Edit bug report at http://bugs.php.net/?id=37220&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=37220&r=trysnapshot44 Try a CVS snapshot (PHP 5.1): http://bugs.php.net/fix.php?id=37220&r=trysnapshot51 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=37220&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=37220&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=37220&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=37220&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=37220&r=needscript Try newer version: http://bugs.php.net/fix.php?id=37220&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=37220&r=support Expected behavior: http://bugs.php.net/fix.php?id=37220&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=37220&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=37220&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=37220&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=37220&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=37220&r=dst IIS Stability: http://bugs.php.net/fix.php?id=37220&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=37220&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=37220&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=37220&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=37220&r=mysqlcfg
