ID:               37220
 Updated by:       tony2001@[...].net
 Reported By:      lbouteille dot ext at francetelecom dot com
-Status:           Open
+Status:           Feedback
 Bug Type:         OCI8 related
 Operating System: Win 2000
 PHP Version:      5.1.2
 Assigned To:      tony2001
 New Comment:

Okay, it works with Oracle 10g on Linux.


Previous Comments:
------------------------------------------------------------------------

[2006-08-09 12:55:56] lbouteille dot ext at francetelecom dot com

Check the detail of the error message : Sounds like XML wasn't valid..
it's working on my Linux server anyway.. maybe some oracle
configuration to deal with XML ?

Oracle Error :: LPX-00245 extra data after end of document
Cause
After the close of the top-level element, more data was found.
Action
The end-element tag for the top-level element must be the last thing in
the document.

------------------------------------------------------------------------

[2006-08-09 12:24:03] tony2001@[...].net

I get only this:
Warning: ociexecute(): ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00245: extra data after end of document

------------------------------------------------------------------------

[2006-08-07 11:30:03] lbouteille dot ext at francetelecom dot com

Here is the SQL command to create database :
CREATE TABLE myTable ( myColumn XMLTYPE NOT NULL)

and then tu put a row in the table:
INSERT INTO myTable VALUES(XMLTYPE('<THETAG myID="1234"> </THETAG>'))

updateXML() and existsNode() are not procedures, they are part of the
Oracle query system (to query XMLTYPE values)

------------------------------------------------------------------------

[2006-08-07 09:54:36] tony2001@[...].net

I don't have table myTable with column myColumn and procedures
updateXML() and existsNode().

------------------------------------------------------------------------

[2006-08-07 09:18:27] lbouteille dot ext at francetelecom dot com

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,'/THETAG[@myID=\"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(); 
?> 

------------------------------------------------------------------------

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