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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).