Home » Developer & Programmer » JDeveloper, Java & XML » XMLTYE - CLOB - DTD
XMLTYE - CLOB - DTD [message #134524] Thu, 25 August 2005 07:33 Go to next message
marrec
Messages: 35
Registered: May 2005
Location: Mühlheim, Germany
Member
hi,

i'm tyring to load a xml-file into a oracle table. i use this code:

DBMS_LOB.createtemporary (l_clob, TRUE);
DBMS_LOB.fileopen(l_bfile, DBMS_LOB.file_readonly);
DBMS_LOB.loadfromfile(l_clob, l_bfile, DBMS_LOB.getlength(l_bfile));
DBMS_LOB.fileclose(l_bfile);

INSERT INTO vettorem.xml_test
( CONTENT)
VALUES
( XMLTYPE.CreateXML(l_clob) --!!!Here the Error occurs!!!
);

This works wonderful til' i insert an external DTD to the xml-File (<!DOCTYPE test SYSTEM "xml.dtd">).
I get the message:
ORA-31001: Ressourcen-Handle oder Pfadname ungültig /xml.dtd

So it seems, that Oracle can't find the DTD-File, but why?

Oracle: 9.2.0.6
OS: MS Windows 2k Server

thx in advance
marrec
Re: XMLTYE - CLOB - DTD [message #134585 is a reply to message #134524] Thu, 25 August 2005 11:53 Go to previous message
marrec
Messages: 35
Registered: May 2005
Location: Mühlheim, Germany
Member
hi,

when i do the link to the DTD-File like this: http://server/xml.dtd --> it works (on the server iis is running)
Previous Topic: XMLTYPE - CLOB - ORA-31001
Next Topic: newbie with casting-problem of org.w3c.dom.Document
Goto Forum:
  


Current Time: Thu Mar 28 13:16:52 CDT 2024