We have a third party application where the debug output provides Oracle error codes and messages, but not the offending SQL. I need to find out what the offending SQL that is causing an ORA-01401, "inserted value too large for column" is, so I can determine the table it is occurring on. Unfortunately it would appear that the trace file output does not log that an error occurred. Does anybody know a way of getting ORA- error codes and their associated SQL statements to appear in the trace file?
Any help would be much appreciated.