473,405 Members | 2,141 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

loading xml file into oracle with dtd validation on,

I am using this method to insert into table of xmltype

INSERT INTO xml_table
VALUES (XMLType(bfilename('XMLDIR','Test_xml.xml'),
nls_charset_id('AL32UTF8')));

xmlfile is like this

<?xml version="1.0" encoding="ISO-8859-1"?><!DOCTYPE metadata SYSTEM "http://www.fgdc.gov/metadata/fgdc-std-001-1998.dtd"><metadata>
<idinfo>
<citation>
<citeinfo>
<origin>MRF</origin>
<pubdate>20040512</pubdate>
<pubtime>08305555</pubtime>
<title>BAS_STREET_SEGMENT</title>
<edition>1</edition>
<geoform>vector digital data</geoform>
<serinfo>
<sername>one</sername>

ERROR at line 2:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00202: could not open "http://www.fgdc.gov/metadata/fgdc-std-001-1998.dtd"
(error 101)
Error at line 1
ORA-06512: at "SYS.XMLTYPE", line 295
ORA-06512: at line 1

I need to used dtd validation, i cannot turn off dtd, is there anyway that i can use dtd validation in oracle.I read a white paper
which says that while inserting into xmltype dtd validation is supported.

db version is Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
&
client i am using there is internet connection, and database server is on different machine(without internet), this file "http://www.fgdc.gov/metadata/fgdc-std-001-1998.dtd" is available on internet.
Pl help, thankx
Nov 6 '09 #1
0 2448

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Rakesh Patel | last post by:
Hi All, I want to load XML file data into database. There is seperate XML file for each record (2000 record) and I want to load these records into a single Oracle database table using...
0
by: Cindy Lee | last post by:
When trying to load a .jar file with the command loadjava -v -u username/password -r .jar I get a bunch of errors like
1
by: Cindy Lee | last post by:
I need to insert rows into MySql database from oracle, which I imagine is a rather common task. The path I decided to take is write a java procedure, as recommended in the manual. However, java...
0
by: J-T | last post by:
I have a CSV file which contains comma seperated data that I need to validate against our database.I was thinking about loading that CSV file into a Typed-Dataset which has our database schema in...
0
by: dioscuroi | last post by:
When I call OCI (Oracle Call Interface) functions in Debug mode of VC+ 7.0, it takes too much time to load oracle debug symbols, and finall failed. Error messages are printed in output window, just...
2
by: Patrick Olurotimi Ige | last post by:
Is it possible to execute a query or do some validation before loading a page.. I have a survey page and i want to validate users before loading the page. I have done it in the page_load. But...
2
by: Jeff Kish | last post by:
Hi. I need to give my customer an sql file that they can run in query analyzer. All the stuff they need to run is in a set of existing files. I'd like to just tell them to load this file (this...
2
by: murthydb2 | last post by:
Hi My requirement is that i have to write a stored procedure in db2 and that will be executed in a batch file . Any system error or validation error that occurs inside the db2 sp during...
1
by: hvellani | last post by:
Okay here is my problem... I have multiple csv files with data in each file. They are connected via foreign keys (with each table having its on primary key). I want to load these tables into an...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.