Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trace column for ORA-01438 Error

556649Nov 19 2007 — edited Nov 20 2007
Hi

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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 18 2007
Added on Nov 19 2007
3 comments
1,877 views