Create the following table:

CREATE TABLE HR.XML (ID NUMBER(15) NOT NULL, XML XMLTYPE NULL, CONSTRAINT XML_PK PRIMARY KEY(ID) NOT DEFERRABLE VALIDATE)

Insert the following records:

INSERT INTO HR.XML VALUES (1, XMLType('<Warehouse whNo="100"> <Building>Owned</Building> </Warehouse>'))

INSERT INTO HR.XML VALUES (2, XMLType('<Warehouse whNo="101"> <Building>New</Building> </Warehouse>'))

run the following select statements:

select * from HR.XML

 

  You will notice the results in query analyzer is showing nulls instead of the xml data.  In version 11 this was working and in version 12 it is no longer working.  AFscriptContext.java line 3644 is throwing an exception on converter.getObject(rs, i+1).  code changed by niels 7/19/12 revision 28218