No, I cannot reproduce this.

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?

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

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

What is your Oracle Client version?

My Oracle Client version: 9.2.0.4.0

Does it help if you use a 10g client?

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

any solution?

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