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.