Connecting Tech Pros Worldwide Forums | Help | Site Map

ORA-31001: Invalid Resource-Handle or Path name

Newbie
 
Join Date: Sep 2009
Posts: 1
#1: Sep 29 '09
Hi,
I am getting an error 'ORA-31001: Invalid Resource-Handle or Path name' while parsing an XML file using oracle DBMS_XMLPARSER. I used an external DTD and attached to this XML file. My sript works fine when I remove the DTD reference from the XML file (DOCTYPE). If any of you are aware, please provide a soultion for this?
Rgds, mohanpva

amitpatel66's Avatar
Moderator
 
Join Date: Mar 2007
Location: Hyderabad, India
Posts: 2,192
#2: Oct 1 '09

re: ORA-31001: Invalid Resource-Handle or Path name


It can be priv's on OS or database level. Check and see what happens if grant yourself the DBA role. Check if the database software owner (ps -ef | grep pmon) is allowed to write in that directory and/or create a file in that directory.
Reply