I have a variable xml_ which is a CLOB data type variable I use to store some XML data (dynamically created) using a PL/SQL procedure. I need to write this CLOB data into a file in my machine. The database server is not my machine.As I don't have direct access to the database server machine, so I would like to know how to write the file into a directory in my local machine without the usage of UTL_FILE package.
Is there any way to do this? I am using Oracle 11g.
I tried to store the XML data in a table with a CLOB column, but it shows <value error> when I try to see the data using PLSQL Developer. I am thinking it is because the size of the xml is too large to open from the PLSQL editor or there is something wrong with the created data. Hence I am trying to write the data to a file to check if there are some invalid characters etc.