Whitespace preservation for PL/SQL XMLType variables
507059Feb 20 2007 — edited Mar 29 2007Hi there,
My application needs to preserve whitespace in all XML processing. I have a document stored in an XMLType column, created with the following CREATE TABLE clauses:
XMLType column doc_content store as clob(tablespace xxxxx)
This XML contains a static template which needs to be copied and modified before being given to the user. However, the copy needs to preserve whitespace just as the original does.
How can I create a copy of the tables's XMLType data for working on in PL/SQL, while still preserving whitespace?
Thanks,
Robert