Hi,
when i import an APEX application into the production environment i get the following error:
Error GET_BLOCK Error.
ORA-20001: Execution of the statement was unsuccessful. ORA-02047: cannot join the distributed transaction in progress <pre>begin execute immediate 'begin dbms_session.set_nls( param => ''NLS_NUMERIC_CHARACTERS'', value => '''''''' || replace(wwv_flow_api.g_nls_numeric_chars,'''''''','''''''''''') || ''''''''); end;'; end; </pre>
The application was before exported from the develepment environment.
Both environments has the APEX version 4.1.0.00.32.
When i drop the following PL/SQL statement at the end of the export file the import works - what's wrong?
begin
execute immediate 'begin dbms_session.set_nls( param => ''NLS_NUMERIC_CHARACTERS'', value => '''''''' || replace(wwv_flow_api.g_nls_numeric_chars,'''''''','''''''''''') || ''''''''); end;';
end;
/
Has anybody an idea?
Best Regards,
Martin