Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

Load XMLTYPE From File - A simple method to load XMLTYPE data from a file.



Sundar said...

Hi , I could not load the given XML file into the Table . Its give errore ora-3210... something exact error i could not remember now . it is telling xml parsing failed ..
could you provide the detail steps with screen shot

Tim... said...

I've just run through the code in the article and it works fine. I'm not going to add screen shots as all they will show is exactly th same code, but in an SQL*Plus window. There are no screen shots to show!

The error message you quote is:

ORA-03210 DBMS_ADMIN_PACKAGE invalid option specification

I don't believe this has anything to do with what I'm doing. I think you may have an issue with your installation.

If you want to persue this I suggest you open a thread in the forum.

http://www.oracle-base.com/forums/

Cheers

Tim...

zahra said...

hi
i coud not convert one query in oracle 9i to XML for send it to another database.
please help me.
my query is in sql and my table are not in xml form.i want to transform them directly with oracle to xml.
what am i doing?
thank you.

Tim... said...

Please ask technical questions on on the forum.

Cheers

Tim...

uday said...

iam getting error as follows
non-existent directory or file for FILEOPEN operation
plz tell me reson behind this

Tim... said...

Questions in the forum, not in the comments!

If you read the error message what do you thin k it means. You've either specified an incorrect directory path when creating your directory object, or the file you are attempting to read doesn't exist in that path.

If both the directory and file exist, then it must be a permissions issue.

If you have any more problems, please use the forum.

Cheers

Tim...

Wouter said...

I had problems loading xml.. I traced this back to the encoding of the xml-file..

When you get strange errors about invalid try the following:
Change the line
dbms_lob.loadfromfile(to, from, length) TO
dbms_lob.loadCLOBFromFile(to, from, Length,dest_offset, src_offset, NLS_CHARSET_ID('UTF8'), lang_context, conv_warning);

NLS_CHARSET_ID('UTF8')-> here the encoding (In my case UTF-8)

define dest_offset, src_offset, langcontext and conv_warning As:
dest_offset NUMBER := 1;
src_offset NUMBER := 1;
lang_context NUMBER := 0;
conv_warning NUMBER := 0;

sam06 said...

Thanks Tim for the article. It is excellent! I did a little changes to make it run through in my database running on an Solaris box.


DO NOT ask technical questions here, that's what my forum is for!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

Add your comments here.
Name
Comment
(max 400 chars - plain text)