My Oracle Support Banner

Unable To Upload Any File From APEX, ORA-22990: LOB Locators Cannot Span Transactions (Doc ID 2779786.1)

Last updated on JUNE 11, 2021

Applies to:

Oracle Application Express (APEX) - Version 20.1 and later
Information in this document applies to any platform.

Symptoms

On: APEX 20.2 version, Flow Builder

When attempting to upload files, the following error occurs.

ERROR
-----------------------
ORA-22990: LOB locators cannot span transactions

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in to APEX workspace
2. Upload a file using APEX component apex_data_parser
3. The error message shows up: ORA-22990: LOB Locators Cannot Span Transactions

**Issue started after after applying October bundle patch on Exadata on OCI

Patch  31965033: applied
Unique Patch ID: 24005385
Patch description: "Database Bundle Patch : 12.1.0.2.210119 (31965033)

Patch  32119956: applied
Unique Patch ID: 23939362
Patch description: "Database PSU 12.1.0.2.210119,Oracle JavaVM Component (JAN2021)"

Changes

 

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.