Oracle error messages

Question

I'm curious about something... is it possible for an Oracle 11 instance to be configured so that it does not return any ORA-?????? error messages?

I've issued many invalid queries where I've misspelled column names, table names... things where I would expect an ORA error message.

Say for security purposes say if a stray java stack trace got exposed to a browser could you force oracle to always show the same bogus error message in the stack trace?

I always get this one:java.sql.SQLException: IO Error: Size Data Unit (SDU) mismatch

I've googled that error up and down, and I do not have any connection or database configuration issues at all! I get it on a per-query basis.

Answer 1

Not a direct solution but I was having the same problem with the SDU mismatch masking the real error. I found a link (http://www.rajivnarula.com/blog/2013/03/13/table-not-found-or-error-not-found/) that gave an indirect way to expose the error:

I tried swapping the JDBC driver with the older ojdbc14.jar and voila ! The real error was exposed : Good old

ORA-00942 (table or view does not exist)

Once I put the table in- everything works fine- with ojdbc14.jar as well ojdbc6.jar

Obviously a pain but useful until someone posts a way to get the underlying error with the newer driver...