#37220 [NoF->Opn]: LOB Type mismatch when using windows & oci8.dll

ID: 37220 User updated by: lbouteille dot ext at francetelecom dot com Reported By: lbouteille dot ext at francetelecom dot com -Status: No Feedback +Status: Open Bug Type: OCI8 related Operating System: Win 2000 PHP Version: 5.1.2 Assigned To: tony2001 New Comment: Yes it is working with Oracle10G on Linux, but what about fixing it on windows ? Previous Comments: ------------------------------------------------------------------------ [2006-08-17 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-08-09 13:17:48] tony2001@php.net Okay, it works with Oracle 10g on Linux. ------------------------------------------------------------------------ [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@php.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) ------------------------------------------------------------------------ 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