SQL Loader problem

From: Anna Li <anna15888_at_hotmail.com>
Date: Tue, 29 Jul 2003 13:39:23 -0800
Message-ID: <F001.005C7B1B.20030729133923@fatcity.com>

Hi All,

I'm trying to use SQL Loader to load data from a text file into a table. However, I always get error as column SKILL_DESCRIPTION field in data file exceeds maximum length where the column SKILL_DESCRIPTION is declared as varchar2(4000). I know the data is <4000 characters, but >1000 characters. It was inserted successfully when I execute insert statement in TOAD as:

insert into skills_tmp values(......);

Is there any option in SQL Loader I have to set in order to load a long string? Thanks for all the inputs in advance.

Anna

---

Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Anna Li
  INET: anna15888_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jul 29 2003 - 16:39:23 CDT