OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Oracle XSU get_xml import function

Hello again,

I am importing 3.2MB file (yes, I know, maybe a little bit big to be using
with the DOM based import function but it works most of the time) and am
getting an OracleXMLSQLException: Inserted value too large for coumn error
when I try to import it. It contains 144 row elements which comprise of a
hiarachical structure replicated by the import table using nested tables.
Funny thing is that when I split the file up into individual XML files
containing only one row all the rows are imported beautifully!!

Anyone had any similar problems with the get_xml Java import function
provided with the Oracle8i XSU or suggest a reason for the problem? I think
that this error may have been caused by dodgy characters in files so that
the parser gets confused and so misses an end tag puting too much data into
a single column but am only guessing? I'm pretty sure that this is not the
case as the file validates against it's encoding and the individual rows
import separately.

I'm confused!!

This email is confidential and intended solely for the use of the 
individual to whom it is addressed. Any views or opinions presented are 
solely those of the author and do not necessarily represent those of 
If you are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, printing, or 
copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.