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 >>> [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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).
