Hi!

I was wondering if anyone here had experienced a simliar problem to mine.

I am updating an Oracle XMLType column with XML built using DOM that is
populated with values from an Excel spreadsheet saved out as a CSV.

My problem is that for certain (apparently) random rows the xml updated
will fail with the error:

Warning: oci_execute(): OCIStmtExecute: ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00217: invalid character 0 (\u0000)
Error at line 1
ORA-06512: at "SYS.XMLTYPE", line 5
ORA-06512: at line 1
in /path/ob/fu/scated/archive.inc on line 1374

I have googled around and a Java fix for the problem seemed to revolve
around a null char being left on the end of the XML string, so I tried
stripping the last char from the string but this did not . I then
used an ordUTF8 function I found in the manual notes to see if I could
find the null in the string - again, no luck.

So my question is whether or not anyone here has a reliable way of
detcting and removing \u0000 chars from strings?

regards,

Mikey

On Mon, Mar 17, 2008 at 3:56 AM, Mikey <frak@upcore.net> wrote:
> Hi!
>
> I was wondering if anyone here had experienced a simliar problem to mine.
>
> I am updating an Oracle XMLType column with XML built using DOM that is
> populated with values from an Excel spreadsheet saved out as a CSV.
>
> My problem is that for certain (apparently) random rows the xml updated
> will fail with the error:
>
> Warning: oci_execute(): OCIStmtExecute: ORA-31011: XML parsing failed
> ORA-19202: Error occurred in XML processing
> LPX-00217: invalid character 0 (\u0000)
> Error at line 1
> ORA-06512: at "SYS.XMLTYPE", line 5
> ORA-06512: at line 1
> in /path/ob/fu/scated/archive.inc on line 1374
>
> I have googled around and a Java fix for the problem seemed to revolve
> around a null char being left on the end of the XML string, so I tried
> stripping the last char from the string but this did not . I then
> used an ordUTF8 function I found in the manual notes to see if I could
> find the null in the string - again, no luck.
>
> So my question is whether or not anyone here has a reliable way of
> detcting and removing \u0000 chars from strings?
>
> regards,
>
> Mikey
>
> --

How about:
$str = str_replace("\0", '', $str);

-Casey

Casey wrote:
> On Mon, Mar 17, 2008 at 3:56 AM, Mikey <frak@upcore.net> wrote:
>> Hi!
>>
>> I was wondering if anyone here had experienced a simliar problem to mine.
>>
>> I am updating an Oracle XMLType column with XML built using DOM that is
>> populated with values from an Excel spreadsheet saved out as a CSV.
>>
>> My problem is that for certain (apparently) random rows the xml updated
>> will fail with the error:
>>
>> Warning: oci_execute(): OCIStmtExecute: ORA-31011: XML parsing failed
>> ORA-19202: Error occurred in XML processing
>> LPX-00217: invalid character 0 (\u0000)
>> Error at line 1
>> ORA-06512: at "SYS.XMLTYPE", line 5
>> ORA-06512: at line 1
>> in /path/ob/fu/scated/archive.inc on line 1374
>>
>> I have googled around and a Java fix for the problem seemed to revolve
>> around a null char being left on the end of the XML string, so I tried
>> stripping the last char from the string but this did not . I then
>> used an ordUTF8 function I found in the manual notes to see if I could
>> find the null in the string - again, no luck.
>>
>> So my question is whether or not anyone here has a reliable way of
>> detcting and removing \u0000 chars from strings?
>>
>> regards,
>>
>> Mikey
>>
>> --
>
> How about:
> $str = str_replace("\0", '', $str);
>
> -Casey

You would think wouldn't you? I even tried asc(0) to no avail.

Well, my problem for now has gone away as an ammended version of the
spreadsheet did not have these errors, but a weird one, without a doubt!

Mikey