Causing ORA errors in a program using JDBC. How to find what’s causing them

javajdbcoracle

So I'm building a java app to interface with the company's database. Whenever it causes an ORA error, it just prints something like the following to system output:

ORA-00911: invalid character

Is there some way I can see what's causing it? Maybe some SQL statement I can use to see the last 10 errors caused on a table or something? I have SQLDeveloper if that might be useful.

Best Answer

Either set tracing on client(jdbc) side. Or you can create system trigger ON SYSTEMERROR see this, but this requires DBA privs.