| XMLTYPE - CLOB - ORA-31001 [message #134525] |
Thu, 25 August 2005 07:33  |
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: XMLTYPE - CLOB - ORA-31001 [message #134549 is a reply to message #134530] |
Thu, 25 August 2005 09:06  |
marrec
Messages: 35
Registered: May 2005
Location: Mühlheim, Germany
|
Member |
|
|
hi,
thx for your message, but this doesn't seem to solve the problem. dbms_xmlsave takes a clob (that's okay) and tries to fill this into a table (in "normal" columns like varchar2, number etc.).
But i have a xmltype-column and the whole xml-file is supposed to be in this column.
this is working with my source, but it can't open the DTD. (ORA-31001).
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
