[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Oracle XSU get_xml import function

  • To: "Xmldev (E-mail)" <xml-dev@l...>
  • Subject: Oracle XSU get_xml import function
  • From: "SHARPE, Ian" <Ian.SHARPE@c...>
  • Date: Fri, 9 Nov 2001 16:33:40 -0000

oracle xsu
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!!
TIA
Cheers
Ian


___________________________________________________________________________
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 
SchlumbergerSema. 
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.
___________________________________________________________________________


PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
 

Stylus Studio has published XML-DEV in RSS and ATOM formats, enabling users to easily subcribe to the list from their preferred news reader application.


Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website. they were not included by the author in the initial post. To view the content without the Sponsor Links please click here.

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.