2.358 SESSION_EXIT_ON_PACKAGE_STATE_ERROR

Use SESSION_EXIT_ON_PACKAGE_STATE_ERROR to force a hard session exit when a session's state has been invalidated.

Exiting sessions after state invalidation avoids errors that can occur when applications mishandle an invalid state.

Property Description

Parameter type

Boolean

Default value

FALSE

Modifiable

ALTER SESSION, ALTER SYSTEM

Modifiable in a PDB

Yes

Range of values

TRUE | FALSE

Basic

No

Oracle RAC

Different instances can use different values.

Set SESSION_EXIT_ON_PACKAGE_STATE_ERROR to TRUE to force a hard session exit under the following circumstances:

  • When a stateful PL/SQL package undergoes modification, the sessions that have an active instantiation of the package receive an ORA-4068 error when they attempt to run it. When SESSION_EXIT_ON_PACKAGE_STATE_ERROR is set to TRUE, the session immediately exits instead of raising ORA-04068. This can be advantageous because many applications are better equipped to handle a session being discarded, and failing to catch errors related to session state, such as ORA-04068, can lead to silent data corruption.

  • When an Oracle Database Multilingual Engine (MLE) module or environment is modified via DDL, sessions that have an active instantiation of the object receive an ORA-4106 or ORA-4107 error. Setting SESSION_EXIT_ON_PACKAGE_STATE_ERROR to TRUE forces sessions to be disconnected if the session state is invalidated. Because many applications capture session disconnect, this option can help simplify the recovery from the invalidation of an existing session state.

Note:

This parameter is available starting with Oracle Database 23ai.