I'm dealing with this issue the last days, which occurs only in apex. Works fine in oracle forms 6i, where designed at first.
I'm using oracle 11g database with greek unicode. I have a database procedure that creates an xml and stores it in a clob, in order to send it via utl_http header. The problem is that i have to make a unicode conversion of the clob column before send it, from AL32UTF8 to ELISO8859P7, using 'convert' function. In that way, i get the http header length and pass it in thehttp header request. Everything working fine when i call the request through database or oracle forms6i. When i try to send the request via apex (version 19), i get this error:
ORA-31011: XML parsing failed.
I also tried to create the xml in apex page and send the request directly through apex, not call it through my database, but i'm getting the same error.
Are there any suggestions, about using http requests in ELISO8859P7 encoding database, and call them through apex?
Thanks in advance,
Sophia K.