Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQLLoader(XMLTYPE)

Posted on 2006-03-28
3
Medium Priority
?
1,050 Views
Last Modified: 2008-01-09
Hi experts,
I am trying to run this SQLloader, but I keep getting this error. Can someone please help me?

SQL*Loader-350: Syntax error at line 4.
Expecting "(", found "xmltype".
xmltype(xmldata)
^
***********************************

LOAD DATA
INFILE *
INTO TABLE nuis TRUNCATE
xmltype(xmldata)
FIELDS
(
ext_fname filler char(20),
xmldata LOBFILE (ext_fname) TERMINATED BY EOF
)
BEGINDATA
nuis3_1.xml
0
Comment
Question by:jkopoku
1 Comment
 
LVL 35

Accepted Solution

by:
johnsone earned 1000 total points
ID: 16312969
I have not done an XML load, but the third line should be:

TRUNCATE INTO TABLE nuis
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question