ID: 37220
User updated by: lbouteille dot ext at francetelecom dot com
Reported By: lbouteille dot ext at francetelecom dot com
-Status: Feedback
+Status: Open
Bug Type: OCI8 related
Operating System: Win 2000
PHP Version: 5.1.2
Assigned To: tony2001
New Comment:
I can't put the code online, but as it is really short, i'm writing it
here :
<?php
//do the connection to the Oracle 9.2.0.7 database
$conn = oci_pconnect($user,$password, $db);
$xml = "<MYTAG/>";
//now let's update the row where myId = 1234 and change the mother tag
'THETAG' to 'MYTAG' (MyColumn is a XMLTYPE datatype and myTable a std
Oracle table)
$query = "UPDATE myTable
SET myTable.myColumn =
updateXML(myTable.myColumn,'/THETAG',xmltype.createXML(:data))
WHERE existsNode(myTable.myColumn,'/[EMAIL
PROTECTED]"1234\"]')=1";
$stmt = oci_parse ($conn, $query);
$clob = OCINewDescriptor($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();
?>
Previous Comments:
------------------------------------------------------------------------
[2006-08-07 09:08:03] [EMAIL PROTECTED]
Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves.
A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external
resources such as databases, etc.
If possible, make the script source available online and provide
an URL to it here. Try to avoid embedding huge scripts into the report.
------------------------------------------------------------------------
[2006-08-07 08:41:18] lbouteille dot ext at francetelecom dot com
I've installed Oracle instant client (10.2)
Same error on my command : "LOB Type Mismatch"...
This is really an annoying bug !
Does everybody working on PHP with Linux only ??
------------------------------------------------------------------------
[2006-05-11 01:00:00] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
------------------------------------------------------------------------
[2006-05-08 14:16:35] contact at infochallenge dot com
The oracle documentation says InstantClient is required for connecting
php to a remote oracle server, what about Local Oracle?
Installing Instant Client on an already existing oracle server doesn't
help, instant client was designed for remote machines
------------------------------------------------------------------------
[2006-05-03 14:11:14] [EMAIL PROTECTED]
Oracle Client and Oracle INSTANT Client are different things.
OCI8 Win32 builds are done using Instant Client, so you can't use OCI8
dlls with outdated Oracle8 and Oracle9 client libraries anymore.
You need to install Oracle Instant Client 10.x (or native Oracle Client
10.x, but it doesn't make any sense, since installing instant client is
much more easier).
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/37220
--
Edit this bug report at http://bugs.php.net/?id=37220&edit=1
