XmlType support

[Ralf]

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

 

[Marco Kalter]

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

 

[Ralf]

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

 

[Ralf]

Can you reproduce the problem?

 

[Marco Kalter]

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

 

[Ralf]

Any progress?

 

[Marco Kalter]

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?

 

[Ralf]

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.

 

[Ralf]

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

 

[Ralf]

Were you able to reproduce our problem?

 

[Marco Kalter]

No, I cannot reproduce this.

 

[Ralf]

Mmm, just downloaded TOAD and used the same select, which results in an internal error
SQL+ however shows the correct result!

Any pointers on where the problem could be?

 

[Marco Kalter]

It might be an Oracle Net issue. You could try the same from a 10g client.

 

[bibi]

Hi
i have the same problem, the Query i try to execute is:

select xmlelement("XXX" , customer_id) as xml from invoice

i get the error:
ORA-24909: call in progress. Current operation cancelled

and the connection to oracle is lost and i cant reconnect.

i am using doa 4.0.3
Oracle Server: 9.2.0.6.0

its run ok in sqlplus, and also in sql navigator (gives (ORAXML) cells results in grid)
in toad it runs (gives ADT cells results in grid) but no values are shown in the output cells in the grid.

i am using windows 2000 SP 4

 

[Marco Kalter]

What is your Oracle Client version?

 

[bibi]

My Oracle Client version: 9.2.0.4.0

 

[Marco Kalter]

Does it help if you use a 10g client?

 

[bibi]

we dont use this version in our company, so i cant check it.

this is a simple query on a simple table:

select xmlelement("XXX" , customer_id) as xml from invoice

customer_id is a number datatype

 

[bibi]

any solution?

 

[Marco Kalter]

At the moment none, other than upgrading to a 10g client.