Pb with SQLPLUS

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 Mon Feb 05 2001 - 09:13:49 CST