I am very new to XML and I have been reading lots of material related to parsing an XML file to insert data into an Oracle database (10g) ...but I'm not sure how to handle my current stumbling block. I've found several 'close' references to similar issues, but I haven't figured out what I need to do to get past this step.
I have created a procedure to parse an XML file and load the data elements into one or more tables. My issue currently is in accessing the XML file.
...xml_file is passed into the procedure. It's set to varchar2; entered as '/opt/data/ext/test.xml'
With the above syntax I am getting ORA-31001: Invalid resource handle or path name "/opt/data/ext/test.xml". The file exists as does the directory. Some internet searching suggested "the path must be created in xml db repository". If this is true, what does it mean?
Separate question which may be a little stupid; as I said, I'm very new to this ...I've registered the schema ...how is the XML validated against it? Is this a separate 'call' before parsing or is there logic within the parsing module which does the validation?