column schema new_value apex_schema
select schema from dba_registry where comp_id = 'APEX';
alter session set current_schema = &apex_schema;

set define off
set verify off
set serveroutput on size  1000000 
set feedback off
begin wwv_flow.g_import_in_progress := true; end; 
/
 
 
--application/set_environment
prompt  APPLICATION  4350  - Oracle APEX Workspace Administration
--
-- Application Export:
--   Application:     4350
--   Name:            Oracle APEX Workspace Administration
--   Exported By:     
--   Flashback:       0
--   Export Type:     Application Export
--   Version: 4.0.2.00.06
 
-- Import:
--   Using application builder
--   or
--   Using SQL*Plus as the Oracle user APEX_040000 or as the owner (parsing schema) of the application.
 
-- Application Statistics:
--   Pages:                  125
--     Items:                263
--     Computations:          30
--     Validations:           72
--     Processes:             81
--     Regions:              508
--     Buttons:              177
--     Dynamic Actions:       20
--   Shared Components
--     Breadcrumbs:            1
--        Entries            119
--     Items:                  5
--     Computations:           2
--     Processes:              0
--     Parent Tabs:            0
--     Tab Sets:               0
--        Tabs:                0
--     NavBars:                4
--     Lists:                 40
--     Shortcuts:              3
--     Themes:                 1
--     Templates:
--        Page:                8
--        List:               17
--        Report:              7
--        Label:               4
--        Region:             35
--     Messages:               0
--     Build Options:          4
 
 
--       AAAA       PPPPP   EEEEEE  XX      XX
--      AA  AA      PP  PP  EE       XX    XX
--     AA    AA     PP  PP  EE        XX  XX
--    AAAAAAAAAA    PPPPP   EEEE       XXXX
--   AA        AA   PP      EE        XX  XX
--  AA          AA  PP      EE       XX    XX
--  AA          AA  PP      EEEEEE  XX      XX
prompt  Set Credentials...
 
begin
 
  -- Assumes you are running the script connected to SQL*Plus as the Oracle user APEX_040000 or as the owner (parsing schema) of the application.
  wwv_flow_api.set_security_group_id(p_security_group_id=>nvl(wwv_flow_application_install.get_workspace_id, 10 ));
 
end;
/

begin wwv_flow.g_import_in_progress := true; end;
/
begin 

select value into wwv_flow_api.g_nls_numeric_chars from nls_session_parameters where parameter='NLS_NUMERIC_CHARACTERS';

end;

/
begin execute immediate 'alter session set nls_numeric_characters=''.,''';

end;

/
begin wwv_flow.g_browser_language := 'en'; end;
/
prompt  Check Compatibility...
 
begin
 
-- This date identifies the minimum version required to import this file.
wwv_flow_api.set_version(p_version_yyyy_mm_dd=>'2010.05.13');
 
end;
/

prompt  Set Application ID...
 
begin
 
   -- SET APPLICATION ID
   wwv_flow.g_flow_id := nvl(wwv_flow_application_install.get_application_id, 4350 );
   wwv_flow_api.g_id_offset := nvl(wwv_flow_application_install.get_offset, 0 );
null;
 
end;
/

/* Page 53 */

--application/end_environment
commit;
commit;
begin 
execute immediate 'begin dbms_session.set_nls( param => ''NLS_NUMERIC_CHARACTERS'', value => '''''''' || replace(wwv_flow_api.g_nls_numeric_chars,'''''''','''''''''''') || ''''''''); end;';
end;
/
set verify on
set feedback on
prompt  ...done