SQL Loader error
From: Kyle G. Miller <kmiller_at_spencergrace.com>
Date: Tue, 7 Mar 2000 19:27:39 -0600
Message-ID: <38c5ac8b.0_at_csoux1102>
Received on Wed Mar 08 2000 - 02:27:39 CET
Date: Tue, 7 Mar 2000 19:27:39 -0600
Message-ID: <38c5ac8b.0_at_csoux1102>
I am using Oracle Data Manager to load a table with
data. I have a Varchar2 (2500) field defined in the table. The data
that I am trying to enter has carriage returns in it. When I run the load
with my control file, it errors out saying "Logical record ended -
second enclosure character not present". Looks like it is
taking my carriage returns as end of fields. the control file is
below. Any one know of any way to get data that has carriage returns in it
to load with Data Manager? I can get it to work with a simple INSERT
command, but not with Data Loader. HELP!!!!
CONTROL FILE:
LOAD DATA
INFILE *
INTO TABLE big
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
trailing nullcols
(show_name, show_location_name, show_address1, show_address2, show_city, show_state, show_zipcode, show_phone, show_fax, show_industry, show_start_date, show_end_date, registration_deadline_date, show_producer, category_name, category_ordering_rules char(2500), sku_regular_price, sku_discount_price, sku_attribute_type, sku_attribute_value)
BEGINDATA
data too big to enter.