XML Database (MOSC)

MOSC Banner

xmlparser failed to use URL as input

edited Dec 10, 2010 4:38AM in XML Database (MOSC) 2 commentsAnswered
 Hello,
I have the following proc. It works fine over Oracle 10. But it gives me errors sometimes for Oracle 9.2.

------------------------
set scan off;
declare

parser DBMS_XMLPARSER.parser;
doc dbms_xmldom.DOMDocument;

begin

 -- Create a parser.
  parser := dbms_xmlparser.newParser;

  -- Parse the document and create a new DOM document.
  dbms_xmlparser.parse(parser, 'http://www.canpar.com/XML/MultiTrackingXML.jsp?language=en&barcode_nums=D002285092907');
  doc := dbms_xmlparser.getDocument(parser);

end;

----------------

The error message is as follows:

ERROR at line 1:
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 449
ORA-29283: invalid file operation
ORA-06512: at "XDB.DBMS_XSLPROCESSOR", line 15

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center