My Oracle Support Banner

ORA-20001 and ORA-02047 Errors When Attempting to Import an APEX Application (Doc ID 1470758.1)

Last updated on AUGUST 22, 2019

Applies to:

Oracle Application Express (APEX) - Version 4.1.0 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Checked for relevance 6-May-2015

Symptoms

Getting the following errors when attempting to import an APEX application:

Error GET_BLOCK Error. ORA-20001: Execution of the statement was unsuccessful. ORA-02047: cannot join the distributed transaction in progress

begin execute immediate 'begin dbms_session.set_nls(param=&gt, "NLS_NUMERIC_CHARACTERS", value=&gt, """"|| replace(wwwv_flow_api.g_nls_numeric_chars,"""","""""")||""""); end;';end;

...

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
Cause
Solution


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