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

Report message to a moderator

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)

Report message to a moderator

Previous Topic: XMLTYPE - CLOB - ORA-31001
Next Topic: newbie with casting-problem of org.w3c.dom.Document
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 01:17:51 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.