My Oracle Support Banner

ORA-01427 Error Trying to Export APEX Application Using Sqlcl (Doc ID 3062529.1)

Last updated on DECEMBER 06, 2024

Applies to:

Oracle SQLcl - Version 24.3 and later
Information in this document applies to any platform.

Symptoms

After upgrading APEX to version 24.1.6 trying to export any APEX application from SQLcl fails with the ORA-01427: single-row subquery returns more than one row.

The application can still be exported using the APEX UI.

Changes

 APEX was upgraded to 24.1.6.

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.