Getting OCI-21500 error

[Vinu]

Hi all,
I have an oracle table which has a column that stores XML in a CLOB format. I have the following query:
SELECT VALUE(p)
FROM XMLTABLE T,
TABLE(XMLSEQUENCE(EXTRACT(XMLTYPE(XML_COLUMN), '/myxml/*'))) p
WHERE T.id=1000
This works fine with SQL Plus but when I tried the same on PL/SQL developer, I'm getting an OCI-21500 error.I'm using version 7.0.2. Please let me know what is causing this error.
Thanks,
Vinu

 

[Marco Kalter]

It might be a client issue. You can try 3 things:

1. Query the getclobval() function instead of the xml instance.

2. Upgrade your Oracle Client (if applicable).

3. Upgrade your PL/SQL Developer version (or try the 8.0.4 trial version).