|
XmlType support
|
Joined: Feb 2004
Posts: 41
Member
|
OP
Member
Joined: Feb 2004
Posts: 41 |
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
|
|
|
Re: XmlType support
|
Joined: Aug 1999
Posts: 22,214
Member
|
Member
Joined: Aug 1999
Posts: 22,214 |
I will check it out. Can you let me know your Oracle Client and Server version, and your Direct Oracle Access version?
Marco Kalter Allround Automations
|
|
|
Re: XmlType support
|
Joined: Feb 2004
Posts: 41
Member
|
OP
Member
Joined: Feb 2004
Posts: 41 |
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
|
|
|
Re: XmlType support
|
Joined: Feb 2004
Posts: 41
Member
|
OP
Member
Joined: Feb 2004
Posts: 41 |
Can you reproduce the problem?
|
|
|
Re: XmlType support
|
Joined: Aug 1999
Posts: 22,214
Member
|
Member
Joined: Aug 1999
Posts: 22,214 |
Not yet, but I still need to test this on 9.2.0.5.
Marco Kalter Allround Automations
|
|
|
Re: XmlType support
|
Joined: Feb 2004
Posts: 41
Member
|
OP
Member
Joined: Feb 2004
Posts: 41 |
|
|
|
Re: XmlType support
|
Joined: Aug 1999
Posts: 22,214
Member
|
Member
Joined: Aug 1999
Posts: 22,214 |
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?
Marco Kalter Allround Automations
|
|
|
Re: XmlType support
|
Joined: Feb 2004
Posts: 41
Member
|
OP
Member
Joined: Feb 2004
Posts: 41 |
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.
|
|
|
Re: XmlType support
|
Joined: Feb 2004
Posts: 41
Member
|
OP
Member
Joined: Feb 2004
Posts: 41 |
We tested it on 2 different machines (same OS, DOA and Oracle) and it fails on both.
|
|
|
Re: XmlType support
|
Joined: Feb 2004
Posts: 41
Member
|
OP
Member
Joined: Feb 2004
Posts: 41 |
Were you able to reproduce our problem?
|
|
|
Re: XmlType support
|
Joined: Aug 1999
Posts: 22,214
Member
|
Member
Joined: Aug 1999
Posts: 22,214 |
No, I cannot reproduce this.
Marco Kalter Allround Automations
|
|
|
Re: XmlType support
|
Joined: Feb 2004
Posts: 41
Member
|
OP
Member
Joined: Feb 2004
Posts: 41 |
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?
|
|
|
Re: XmlType support
|
Joined: Aug 1999
Posts: 22,214
Member
|
Member
Joined: Aug 1999
Posts: 22,214 |
It might be an Oracle Net issue. You could try the same from a 10g client.
Marco Kalter Allround Automations
|
|
|
Re: XmlType support
|
Joined: Sep 2005
Posts: 31
Member
|
Member
Joined: Sep 2005
Posts: 31 |
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
|
|
|
Re: XmlType support
|
Joined: Aug 1999
Posts: 22,214
Member
|
Member
Joined: Aug 1999
Posts: 22,214 |
What is your Oracle Client version?
Marco Kalter Allround Automations
|
|
|
Re: XmlType support
|
Joined: Sep 2005
Posts: 31
Member
|
Member
Joined: Sep 2005
Posts: 31 |
My Oracle Client version: 9.2.0.4.0
|
|
|
Re: XmlType support
|
Joined: Aug 1999
Posts: 22,214
Member
|
Member
Joined: Aug 1999
Posts: 22,214 |
Does it help if you use a 10g client?
Marco Kalter Allround Automations
|
|
|
Re: XmlType support
|
Joined: Sep 2005
Posts: 31
Member
|
Member
Joined: Sep 2005
Posts: 31 |
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
|
|
|
Re: XmlType support
|
Joined: Sep 2005
Posts: 31
Member
|
Member
Joined: Sep 2005
Posts: 31 |
|
|
|
Re: XmlType support
|
Joined: Aug 1999
Posts: 22,214
Member
|
Member
Joined: Aug 1999
Posts: 22,214 |
At the moment none, other than upgrading to a 10g client.
Marco Kalter Allround Automations
|
|
|
|
|
|