This content has been marked as final. Show 5 replies
Your error is related to how youd efine your oracle directory.
This is a name you create which you must point to an exsiting directory on the database server and oracle must have privileges to read and write to this directory.
eg for unix
or for windows:
create or replace directory my_dir as '/tmp';
So here you specify my_dir as the directory name.
create or replace directory my_dir as 'c:/temp';
Can you log in as the oracle user and write to that directory.
Does the filesystem directory exist?
Is it on the database server?
Post values od p_comms_dir_path and p_xmlfile
Assuming p_xmlfile is file name in base directory p_comms_dir_path and both are valid, use:
dbms_xmlparser.parse(p,p_xmlfile);Keep in mind, p_comms_dir_path is oracle directory object name that points to directory on datbase server, not on client box. Also, user oracle must have read permission on file p_xmlfile.