2.134 ERROR_MESSAGE_DETAILS

Use ERROR_MESSAGE_DETAILS to control whether the database raises an additional stacked error message, with further details about the data values encountering the error, when displaying error messages.

Property Description

Parameter type

String

Syntax

ERROR_MESSAGE_DETAILS = { ON | OFF | DISALLOWED }

Default value

ON

Modifiable

ALTER SESSION can be used to set this parameter to ON or OFF.

ALTER SYSTEM can be used to set this parameter to ON, OFF, or DISALLOWED.

Modifiable in a PDB

Yes

Basic

No

Oracle RAC

Different instances can use different values.

This parameter allows you to instruct the database to show or omit explanatory details about data values causing an error. Providing this information usually makes it easier for the user to understand why the error occurred. If this is not desired, this parameter can be used to omit these additional details.

The detailed error message is being raised as a stacked error, meaning that applications will see the root cause error as the main error and will have to further traverse the stack to gain insights into the details. SQL command line tools will automatically traverse the entire stack and print the entire error message stack.

You can set this parameter for the database instance or PDB with the ALTER SYSTEM statement, or for the current session with the ALTER SESSION statement, using these values:

  • ON: The database will provide additional explanatory details when displaying error messages. This is the default.

  • OFF: The database will not provide additional explanatory details. This is the behavior prior to Oracle Database 23ai.

Additionally, you can set the following value only at the database instance or PDB level with the ALTER SYSTEM statement:

  • DISALLOWED: The database will not provide additional explanatory details, and users cannot override this behavior for the current session with the ALTER SESSION statement.

Note:

This parameter is available starting with Oracle Database 23ai.