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
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
|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.|