ORA-40 Not Returned at the Top of the Errorstack when Oracle Text Query is Cancelled by Resource Manager (Doc ID 1517586.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Text - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

When a Text query is cancelled by Resource Manager because of reaching the time limit set, SWITCH_TIME limit, the error

is not always at the top of the errorstack, while it should be because this is the real cause of the query interrupted.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms