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 don't actually state what you are programming in, but I assume you are using PL/SQL 2.0. Pre-compiled PL/SQL is hard to debug because of its lack of interfaces to the otherside world. The approach I take is to write a small packaged function that accepts a char param, and places the param in to an oracle pipe. You then have to write a 3 gl program to sit on that pipe waiting for a message. Insert in to your code suitable calls to that function, passing it the values of your variables to see which one too large, ie

   package.function('acc no is ' || to_char(acc_no));

Info about oracle pipe can be found in the Oracle 7 Server Applications Developer's Guide.

If any-one knows a better way of debugging PL/SQL blocks, or has experience of maintaining PL/SQL blocks in the region of 1500 to 2000 lines of code (or larger), please share any hints we use.

Tim Jinkerson
Technical Consultant
MSS International
Egham Received on Wed Jul 05 1995 - 00:00:00 CEST