Enabling Detailed Request Error Messages for a Specific Schema

For development or debugging purposes, you can enable detailed request error messages to appear for a specific schema in an Autonomous Database.

To set this up, run the following code block:

Note:

You need the ORDS_ADMINISTRATOR_ROLE to run this code block.

begin
ords_admin.set_property(
   p_schema => 'HR',
   p_key => 'debug.printDebugToScreen',
   p_value  => 'true'
);
end;
/

Subsequently, any user request that produces an error response will include a detailed message, including a stack trace.

After debugging, turn the schema-level configuation off by setting the parameter to false.

Note:

This setting must not be enabled on productions systems due to the risk of sensitive information being revealed to an attacker.