My Oracle Support Banner

ORA-22289: Cannot Perform Operation On An Unopened File Or LOB (Doc ID 3006083.1)

Last updated on FEBRUARY 22, 2024

Applies to:

Oracle REST Data Services - Version 23.1 and later
Information in this document applies to any platform.

Symptoms

Using a trigger defined as:


For Any ORDS request, a new row in table ERROR_LOG reporting error ORA-22289 is added.


It is possible to exclude SERVERERROR 22289 but error is still generated by ORDS generating useless additional workload.

Changes

 added the trigger for logging

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.