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 04, 2018

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.