KSGokul wrote:I am in search of the "xml_content" bit, that is the used functions and operators, that is XQuery, XML/SQL part.
a) select XmlSerialize( CONTENT xml_content ) from table;
b) select xml_content from table;
where xml_content = xmltype column name
table = table name
Please let me know, if you need any more details.
I am right now not in a position to disclose the xml_content used. but i can say that its of size 21k and i use Binary XML Secure File as the storage option. I have compression enabled. Do you think you would be able to help out without looking at the actual XML?At least, give us the code you're using (not pseudocode), or a simplified version of it sufficient to reproduce the issue.
Or if you try it out in any ~21k XML content, are you not facing the same issue?