Re: Sql*Loader problem...

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Thu, 13 Mar 2003 12:14:34 -0800
Message-ID: <F001.005697A3.20030313121434@fatcity.com>

JL,
 When you describe the field type in the SQLLoader file set the CHAR(4000)
as the field description. You are correct in saying that the default is CHAR(255).
As an example;

col1 terminated by "," ,
col2 CHAR(4000) terminated by ","
...
Ron
>>> joseluis_delgado_at_yahoo.com 03/13/03 01:44PM >>>
Hi...

I would like to receive a bit of your help (I've been looking at Metalink with no luck).

I'm having a sql*loader problem when I try to insert records in a table field.

The problem is:
my data file has a column with MORE THAN 255 characters long, and sql*loader rejects the records that exceed that limit!

The data are generated by an app called NetCache. And, for auditing, we need to load the data into the oracle database.

I'm having problems with just one column: URL_VISITED varchar2(4000)

Any ideas, help would be appreciated!.

I need to load a string like this:
(A workaround could be SUBSTRac
just the first 255 chars )

'http://www.hotmail.msn.com/cgi-bin/sbox?did=1&t=4zO *OzYH5DI!K5JDg2lw3GV*Z17S74coVgj5bSbi3Idhx6CPvVsK3Eh bHes!GVxjYRKdxmfIAmoF1SvuqW0Vd5rQ$$&p=4wcx4xWmyGq6jd OZdt9566bmc4SziYsk6XKA60n*bkWwcK3UuKf8dzl1ykTjzYsAhK YN8wfQ6ay2rrR1FSRXj*djcyllOvUfV5H8drR6iESnR6PEig6lqH Cv7iH*opeUYbDd4IlZxxwRC6pqrKos5CLOW2iSBE5fp4L2g71b7E LgER0F!Eiw0XdUZsVKN!a17yI*bRtievO7lRyJefsNcjcA$$&js=yes'

Regards!
JL

---

Do you Yahoo!?
Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Jose Luis Delgado
  INET: joseluis_delgado_at_yahoo.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

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 Thu Mar 13 2003 - 14:14:34 CST