ORA-20001 and ORA-02047 Errors When Attempting to Import an APEX Application
(Doc ID 1470758.1)
Last updated on FEBRUARY 18, 2021
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
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=>, "NLS_NUMERIC_CHARACTERS", value=>, """"|| replace(wwwv_flow_api.g_nls_numeric_chars,"""","""""")||""""); end;';end;
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