SQL & PL/SQL

Hello

We have few environments (dev, test, acceptance and production). All are running the same version of Oracle: 10.2.0.5.0.

However in some of them conversion from string to xmltype works, in others it does not.

Offending code:

select xmltype(
'<?xml version="1.0"?>
      <xliff xmlns="urn:oasis:names:tc:xliff:document:1.2" 
              xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
              xsi:schemaLocation="urn:oasis:names:tc:xliff:document:1.2 xliff-core-1.2-transitional.xsd">
</xliff>
') from dual;

Any change to xmlns, xmlns:xsi or xsi:schemaLocation makes it work.

Can anyone suggest what to look for (difference between databases)?



Thanks in advance

MJ

Edited by: MarcinJ13 on 2012-04-24 08:20