"Exotic" datatypes, like large objects, object types, XML documents, etc. are being used by more and more Oracle development teams. And those teams, of course, are using one of many different IDEs for PL/SQL, including Toad, SQL Navigator, PL/SQL Developer, SQL Developer, etc.
These IDEs come with source code debuggers, but unfortunately Oracle's implementation of the Java Debug Wire Protocol (JDWP) comes with a number of limitations, including:
- CLOB: Only the first 511 characters are shown.
- BLOB: Only the first 510 bytes are shown.
- XMLTYPE, ANYDATA, ANYDATASET, ANYTYPE: No value is shown.
If you'd like to see Oracle address these limitations in the upcoming 12c version, check out my PL/SQL Obsession blog for details.