SQL-Loader - searching for Strings

From: <andreas.krisor_at_gmx.net>
Date: 11 Mar 2005 10:21:36 -0800
Message-ID: <1110565296.648283.206020@z14g2000cwz.googlegroups.com>

Hi,

I've got a problem while loading data with the SQL-Loader; consider the following CTL:

LOAD DATA
infile *
append
into table tab_one
trailing nullcols
(

Col_1 enclosed by "<Tag1>" AND "</Tag1>" Col_2 enclosed by '<Tag2 "' AND '"'
)

begindata
<?xml> <Tag1>myinfo</Tag1> lkadjflk <Tag2 "myinfo2"> lots_of_data

The data I'd like to load in my table is between the specified strings
(myinfo).

The log-file rejects the record and contains the following message: "Initial enclosure character not found"

What should I use as field-specification. I've already tried to specify it with single quotation-marks, but the error persists.

Greetz,

Andreas Received on Fri Mar 11 2005 - 12:21:36 CST