Skip to Main Content

SQLcl

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

PROJECT DEPLOY fails while importing APEX app with ORA-20987

YuriAPFeb 10 2025

Hello

I have a trouble while importing APEX app with PROJECT DEPLOY

Running Changeset: releases\apex\f700\f700.xml::INSTALL_700::SQLCLOPAS70I1
Migration failed, error reported:
declare
*
ERROR at line 1:
ORA-20987: APEX - Invalid workspace ID. - Contact your application administrator.
Details about this incident are available via debug id "3001".
ORA-06512: at "APEX_240200.WWV_FLOW_ERROR", line 1150
ORA-06512: at "APEX_240200.WWV_FLOW_ERROR", line 1608
ORA-06512: at "APEX_240200.WWV_FLOW_APPLICATION_INSTALL", line 82
ORA-06512: at "APEX_240200.WWV_FLOW_APPLICATION_INSTALL", line 91
ORA-06512: at line 30

I suspect, I need somehow to specify Workspace ID, but how?

Or something else?

APEX 24.2, Oracle 23.6 Free, SQLCli 24.3 on both source and target DBs.

Comments

BluShadow Mar 18 2024

Oracle support documents are available to paying customers through the support portal: support.oracle.com

If you are not a paying customer then I'm afraid you won't have access to the document, and it is a breach of any customer's agreement with Oracle to supply such support documents to others.

1 - 1

Post Details

Added on Feb 10 2025
2 comments
102 views