OCI-21500

[stevesco_30]

When i do a select * from

which contains a column of type XMLTYPE. In PLSQL Developer it creates a error OCI-21500 internal error code, arguments [kghfrh:ds],[0x78AF914],[],[],[],[],[],[]

The Oracle Server vesion is 10g Release 2
The Oracle Client is the InstantClient

Can you Help?

Thanks

Stephen

 

[stevesco_30]

Sorry Forogot to Say, I have PL/SQQL Developer version 6.06.947

 

[stevesco_30]

On further investigation, This error also happens when I use the Direct Oracle Access components v4.0.7.1.

Also If I run the query through SQL Window in PLSQL Developer the error appears, if i run it through the command windowin PLSQL Developer window the error does not appear

 

[Marco Kalter]

We'll check it out. As a workaround you can select xmltype.getclobval() instead.

 

[stevesco_30]

That's great, but I have a problem with Direct Oracle Access Components. It comes up with the same error, When you use the Type TXMLType.Create, which makes the application useless at this point