Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Database parameter to enable detailed error messages (for ORA-00942 and others)

MortenBratenSep 21 2017

Certain error messages would be more useful if they contained more details.

For example, "ORA-00942: table or view does not exist" does not tell us which table does not exist. It would be vastly more useful if the error text was "ORA-00942: table or view SOME_NONEXISTENT_TABLE does not exist".

The lack of details is usually ascribed to security, ie that it would be bad for security if someone could check which tables exist or not by running various spurious queries.

The idea is to introduce a database parameter that enables more detailed error messages. By default it would be disabled, and production databases would typically run with this setting disabled. However, for development databases it could be enabled, making the life of the developer easier.

Comments
Post Details
Added on Sep 21 2017
5 comments
354 views