Re: Pb with SQLPLUS

In article <95mfdq$ik9$1_at_reader1.imaginet.fr>,   "Frédéric MOLINIERES" <fmolinieres_at_intelligence-process.com> wrote:
> Hi all,
>
> I try to execute a batch job wich insert in a bdd lots of enregs
 (about
> 160000). There are in a flat text file readen by pl/sql with utl_file
> package.
> But my pl/sql stop after inserting 3000 enregs (3000 lines of my flat
> file).
> - I proceed a commit on each enregs step by step
> - the enreg on wich the process stop with former and follower, are
 tested
> alone and are ok.
> the error message is ORA-06502: PL/SQL : numeric or value error :
 string
> buffer too short
> if i reexecute the process (with the first 3000 commited), he stops
 on enreg
> 5000 with the same error message.
>
> Someone have an Idea ?
>
> Thanks a lot
>
> Fabrice Brignano
> Frédéric Molinieres
>
>

What does your code look like?

--
Jining Han
Sallie Mae


Sent via Deja.com
http://www.deja.com/