I am using PL/SQl to create an XML file. The procedure calls XMLDOM.writeToFile procedure to create the xml object to a file. The file should be created on the file server which is different than the database server. I am getting ORA-20000 when I try to create the xml file on the file server. If I do not give the file path, the file is created in tne ORACLE_HOME directory.
The part of my code that is giving the error is as follows:
proj_dir -- this variable contains the directory path to create the file on the server
filename := proj_dir ||'\'||'XFRTEST.xml';
If I modify the code as
filename := 'XFRTEST.xml';
The file is created in the oracle_home directory , that is not desirable.
How do I create the file on the file server?