Re: Problem with SQL-Loader

I have found that SQL*Loader is limited to 255 characters per field.

(it may be 256 characters.)

-Gary

"Nils Appel" <Nils_Appel_at_web.de> wrote in message news:954mp9$otk$04$1_at_news.t-online.com...
> Hi,
>
> I'm trying to import data from a large, comma seperated file using
> SQL-Loader. The file looks like this:
>
>

 140,bmForm=search&bmFormID=954570676337&bmIsForm=true&bmPrevTemplate=main%2F
>

 cust_serv\.jhtml&bmHidden=SEARCH_INPUT%3C%3EobjectTypes&SEARCH_INPUT%3C%3Eob
>

 jectTypes=PRODUCT&bmHidden=SEARCH_INPUT%3C%3EobjectTypes&SEARCH_INPUT%3C%3Eo
> bjectTypes=SKU&bmHidden=SEARCH_I,..........
>
> The database fields are varchar2(500) each.
>
> It works fine if I import just the first field (in this record "140") but
 if
> I try it with second field it fails saying "Error -2 writing to badfile".
 It
> created an empty badfile in my home. I know that I have writing priviliges
> there.
>
> Possibly the problem is caused by the special characters in the data. Does
> anyone have some experience with such import problems? Please help.
>
> Nils
>
>
Received on Tue Feb 06 2001 - 15:45:43 CET