Could SQLLoader be better?
--
A.M. Andreyev,
ORACLE DBA
"Frédéric MOLINIERES"
<fmolinieres_at_intelligence-process.com>
wrote in message
news:95mfdq$ik9$1_at_reader1.imaginet.fr...
> 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
>
>
Received on Thu Feb 08 2001 - 13:13:40 CST
