ORA-24805 LOB Type mismatch

Hello,

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)

In my PHP application, i use this kind of 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();

(trying to update an XML field of my database, This works fine on the production server, but on my dev computer it will say : ORA-24805 LOB Type mismatch (error at line OCIExecute(...))

I'm lost.. I tried to compare the PHP configuration between both environnement and the only difference I found is : - production php is compiled --with-oci8 - dev php is using php_oci8.dll through php.ini Does it makes any difference ? is this coming from my oracle client installed on the dev ? (does this one matter by the way ?)

thanks for all ur answers,
Lionel Received on Wed Apr 26 2006 - 08:38:48 CDT