Trace column for ORA-01438 Error
556649Nov 19 2007 — edited Nov 20 2007Hi
I encountered the following error while trying to insert into a table using bind variables in a program:
ORA-01438: value larger than specified precision allows for this column
I enabled trace for 1438 with errorstack level 4 in order to capture the bind variables being passed into the sql using the following sql:
alter system set event='1438 trace name context forever, level 4' scope=spfile;
A trace file is being generated after encountering the error again and I tried to use tkprof to read the trace file, however, I do not see any bind variable in the file. Is there something wrong? How do I trace the column which is causing the problem?
Thanks in advance!