ORA-20001 and ORA-02047 Errors When Attempting to Import an APEX Application

(Doc ID 1470758.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Application Express (formerly HTML DB) - Version 4.1.0 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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms