ORA-46069
operation disallowed in an application session
Cause
Operations were blocked while an application was attached. The following are the common cases:
- An attempt was made to enable or disable database roles (through the 'set role' statement) in an application session.
- An attempt was made to destroy a direct logon Oracle Real Application Security (RAS) session while the session was active.
- An attempt was made to destroy a regular RAS session while the session was attached.
- An attempt was made to perform certain session operations (for example, ATTACH_SESSION, DETACH_SESSION, DESTROY_SESSION, ASSIGN_USER, SWITCH_USER, ENABLE_ROLE, DISABLE_ROLE) in the 'parse as user' statement while currently attached to a RAS session.
- An attempt was made to change the password for an external RAS user.
Action
Do not attempt to execute the SET ROLE statement while attached to an application session. Do not attempt to change the password for an external RAS user. Try using the FORCE option when attempting to destroy an application session. Or, detach the application session first, then try the operation again.