how to catch sql sentence that throws an error
jsanzaMay 12 2011 — edited May 12 2011Hello,
An application is not working because throws the following oracle sql error:
ORA-01406: fetched column value was truncated
There are no developers whose maded this application and not source code ...
I am trying to find out what sql sentence from this program is throwing this error ... and fix the column table size , ...
Googling i've found that an solution could be create a system trigger to catch errores, but these trigger don't show this error and it happens ...
http://stackoverflow.com/questions/492705/is-there-any-way-to-log-all-failed-sql-statements-in-oracle-10g
Any way to get what sentence throws ora-01406 ??
thank you