Binary vs CLOB XMLTYPE fields
Posted: Mon 18 Mar 2019 18:40
Hello,
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:. But if I do , then try , I get an error. I believe this is because the former returns XMLTYPE as CLOB and the latter as Binary.
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
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 dualCode: Select all
Select * from testI 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