Re: Problem using bulk insert in OCI

From: Jerry Gitomer <>
Date: Thu, 26 Aug 1999 10:38:24 -0400
Message-ID: <7q3k5k$cl1$>

Hi Jorge,

    If you are not changing the table definitions, or the input data files between runs all that is left is hardware or system software that is generating extraneous characters.

    Run your diagnostics and be sure to run any RAM diagnostics you have since Oracle tends to be very demanding on RAM (as well as disks). Also, if the input data is going across a network to your server you should also look at the network traffic at a byte level.

Jerry Gitomer

Jorge Silva wrote in message <>...
>Hi all,
>I am trying to insert data into a table using bulk insert, and I
>receiving the following error:
> ORA-01438: value larger than specified precision allows for
this column
>The table has 110 columns and I get the error when I increase
either the
>number of rows being inserted or the number of columns. No
matter the data
>being inserted.
>When I retry to insert the same data once again, immediatly
after the failed
>insert, it inserts the data correctly with no error.
>For instance, I try to execute a bulk insert with 110 columns
and 100 rows.
>When I get the error I execute the insert one more time not
changing any
>values in the arrays and the insert runs successfully.
>I am using Oracle on Windows NT.
>Has anyone had this problem?
>Anyone has any idea that can help me?
>Jorge Silva
Received on Thu Aug 26 1999 - 16:38:24 CEST

Original text of this message