I am using ODAC in full unicode mode, so if I select an XMLTYPE column from database, I get an AV. I understand this is due to an OCI limitation.
If I put this query into a TSmartQuery, there is no error:
Code: Select all
select xmlelement("Test", dummy) XMLTest from dual
Code: Select all
create table test as select xmlelement("Test", dummy) XMLTest from dual
Code: Select all
Select * from test
I was examining the FieldDesc for each of these fields (after calling TSmartQuery.Prepare), but could not discover a way to tell the difference between these two fields. Is there a way to tell them apart by either TFieldDesc or TFieldDef?
Thanks,
John Dorlon