I am writing a procedure that creates a query and same is stored as CLOB in a database table. Below is a sample test program for same. I am using UTF-8 to accomodate Chinese data. The CLOB however doesn't contain valid chinese data. Please guide me on what needs to be done....

Oh, In that case do I have any other XML api that would support NCLOB and eventually store chinese data or is there some other solution available to this problem..

Edited by: user3463284 on Aug 9, 2012 8:31 AM

I was going through Oracle XML DB Developers Guide 11G and it has below statement
[refer -http://docs.oracle.com/cd/E24693_01/appdev.11203/e23094/appjspec.htm]
To handle, store, or generate XML data that contains multibyte characters, Oracle strongly recommends that you use AL32UTF8 as the database character set.