We have the following problem:

TOracleDataSet that retrieves the content of a view. This view contains two fields: an integer and a XmlType-field. The Xmltype-field works fine for a simple view, but the following view (containing SQL/XML) leads to an error:

CREATE VIEW VIEW_TEST_XML AS
select t.id as xml_id,
XMLElement("xmlblob"
) as xmldoc
from test t

retrieving the content in a dataset leads to

ORA-24909: call in progress

while performing TXMLType.GetXML

I will check it out. Can you let me know your Oracle Client and Server version, and your Direct Oracle Access version?

Oracle client and server: 9.2.0.5
DOA : latest download 4.0.6

btw: The xmltype itself is not the problem. The use the SQL/XML functions is the problem. I have other views with xmltype-fields and that works fine (which uses the same function TXMLType.GetXML).

Thanks in advance

Can you reproduce the problem?

Not yet, but I still need to test this on 9.2.0.5.

Any progress?

I just tested this on a 9.2.0.5 client and server, and it works okay too. Can you let me know your Oracle Server OS and also send me the TEST table definition?

Server OS is Windows 2000 Professional SP4

The same error occurs for:

CREATE VIEW VIEW_TEST_XML AS
select XMLElement("xmlblob"
) as xmldoc
from dual
/

So the test table has no influence.

We tested it on 2 different machines (same OS, DOA and Oracle) and it fails on both.

Were you able to reproduce our problem?