SQL Window hangs on query returning xmltype

[whip]

The following query makes the SQL Window hang:

SELECT xmlelement("a", dummy)
FROM dual;

The result grid contains , the query seems to run forever and cannot be cancelled.

//
I know, the correct way to do this in PLSQL Developer is
SELECT xmlelement("a", dummy).getclobval()
FROM dual;
//

 

[Marco Kalter]

Which PL/SQL Developer version and Oracle Client version are you using?

 

[whip]

PLSQL Developer: Version 6.0.2.880 (MBCS)
OCI is 9.2
RDBMS is 9.2.0.4

I have two oracle homes with OCI 9.2, either makes the above query hang. A third home contains OCI 9.0; changing to this home the xmltype value is skipped from the result grid, otherwise the query runs fine.

 

[whip]

So is this
- a bug in OCI 9.2
- a problem with my OCI 9.2 installation(s)
- a bug in PLSQL Developer
- a feature ?

Am I supposed to downgrade to 9.0? Can you reproduce the problem?

Cheers,
Tom

 

[Marco Kalter]

I tested this, but it seems to work just fine on 9.2. Oracle Net 9.0 does not support the XMLTYPE object, so that's why it is skipped. I don't really have an explanation yet why it hangs in your situation.

 

[-IceTea-]

actually,
i also encounterd similar problems, these occur
with anything xml related when using certain syntaxes. pl/sql developer just seeems to "hang",
ran the query in sql navigator and it ran just fine.

 

[Marco Kalter]

Is this also on 9.2? Does getclobval() fix the problem in this case as well?

 

[-IceTea-]

yes to both

platform is windows and version is 9.2.0.3

 

[Michael Doel]

I had the same problem when using an Oracle 9 client. Using an Oracle 10 client solved the problem.

Regards,
Michael Doel
Wildher ICT Solutions

 

[Ed Delaney]

FYI.
We just opened a TAR with Oracle that is now an official bug and in Oracle development. The issue does not occur in 10g. It concerns Oracle hanging in certain cases when PL/SQl manupulates complex Oracle object types. I don't have any more deatails at this point.
Ed Delaney
SungardSct