ORA-01401: Value inserted too large for column

[thiago.sousa]

Guys, how do I find out which value is greater than the column ... ????
urgently.


Thanks;

[dr_gori]

I think you have to go testing ... I think a debug was to solve.

[thiago.sousa]

This error only takes place on the client, is a very complex and difficult to debug routine.

I wanted some command or trigger to get the SQL that was running and see the value of the columns.

[dr_gori]

An idea is to do the following:
puts an exception in this insert.
Within this exception, you do the same insert for a table with the fields much larger than normal ...

Example:
If the field is Varchar2 (15), creates a table with this VARCHAR2 (200) field, etc.

ie, if error, exception will insert on this other table. After inserting, you gives a raise and for the application. Then you can take a calm what is being inserted ...

There must be better ways ... But I think so you were going to be able to know what is being inserted ...

If you did not want to insert, put a dbms_output for each field on the exception ... hence the SQL * plus your routine ..: - /

[thiago.sousa]

I imagined the following.
some way to do this in a generic way.
Because this happens routinely, the programmers end up forgetting to limit the fields and I get in this impasse.

I wish I did not have to move on their routines, I would like to do everything in the bank, in a way that can be dynamic.

[ruevers]

It generates a trace of the guy's session, then just look there =