My Oracle Support Banner

Reading XMLTYPE From Table in PLSQL Shows Incorrect Data Second Time Onward (Doc ID 2430329.1)

Last updated on AUGUST 08, 2018

Applies to:

PL/SQL - Version to [Release 12.2]
Information in this document applies to any platform.


Reading XMLTYPE from table in PLSQL gets corrupted and shows incorrect data second time onward.

Though getStringVal works fine but it has limit up to 4Kb.

It can be explained with the help of below example

Issue is not seen in latest versions.


Upgraded to


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.