Re: sql loader char limit ?

From: Jurij Modic <jmodic_at_src.si>
Date: Mon, 22 Feb 1999 12:53:13 GMT
Message-ID: <36d14f4c.19283123_at_news.siol.net>

On Mon, 22 Feb 1999 12:29:11 -0000, "JR" <jose_raposo_at_yahoo.com> wrote:

>Hi
>Does sql loader has a limit on the chars it can load?
>
>I've a table with varchar2(700) and I can't load the
>string. The log has:
>"Field in data file exceeded maximum specified length"
>The ctl file has:
>...
>insert into xpto
>(num_seq_reg sequence(1,1) ,
> registo
> terminated by X'10' )
>
>I've tried a insert into... and it worked fine.
>
>btw, its the 7.3 version

The default maximum length of delimited fields is 256 bytes. If you have longer field in your infile you must specify its maximum length explicitely as CHAR(max_length). In your case:

insert into xpto
(num_seq_reg sequence(1,1) ,
 registo CHAR(700) -- MAX LENGTH SET TO 700  terminated by X'10' )

Regards,

>Thanks in advance

HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Mon Feb 22 1999 - 13:53:13 CET