Re: ORA 01401 error inserted value too large for column

In article <333981103wnr_at_rossuk.demon.co.uk> Rod Green <Rodgr_at_rossuk.demon.co.uk> writes:

>We are getting this error. I have debugged the program code but cannot
>find which column is giving the error.
 

>I tried producing a trace file to see if that helped, but it does not
>show where the error occurred, or not that I can see.
 

>Any ideas
>-- -------
>--------------------------------------------------------------------| Rod
> Green EMail rodgr_at_rossuk.demon.co.uk || Mail
> sent via Demon Internet - Full IP for 10/Month Tel:0181 371 1234
>|---------------------------------------------------------------------------

You are probably trying to insert too large a number into a number column i.e. trying to assign a value of 9999 to a column defined as NUMBER(3,0)

Find which INSERT or UPDATE statement is responsible then print out the values of all variables being Inserted (i.e. printf in Prod*C or DBMS_OUTPUT if PL*SQL).

Then increase the size of the column with the problem i.e. ALTER TABLE tablename

      MODIFY (small_column_name NUMBER(10,2));

(Note: size NUMBER according to requirement)

Hope this is a help

Robin Parker
parkerr_at_logica.com Received on Wed Jul 05 1995 - 00:00:00 CEST