Rem  Copyright (c) Oracle Corporation 1999 - 2007. All Rights Reserved.
Rem
Rem    NAME
Rem      rt_zh-cn.sql
Rem
Rem    DESCRIPTION
Rem      Install Chinese version of Application Express runtime
Rem
Rem    NOTES
Rem      Assumes the Application Express owner.
Rem      Note that the NLS_LANG must be properly set in the environment
Rem      prior to running this script or character set conversion can take place
Rem      The character set portion of NLS_LANG must be set to AL32UTF8
Rem         Example: AMERICAN_AMERICA.AL32UTF8
Rem 
Rem    REQUIREMENTS
Rem      - Oracle 9.2.0.3 or greater
Rem
Rem    Arguments:
Rem      None
Rem
Rem    MODIFIED    (MM/DD/YYYY)
Rem      jkallman   10/04/2007 - Created 

prompt .  ____   ____           ____        ____ 
prompt . /    \ |    \   /\    /     |     /    
prompt .|      ||    /  /  \  |      |    |    
prompt .|      ||---    ----  |      |    |---

prompt .|      ||   \  /    \ |      |    |  
prompt . \____/ |    \/      \ \____ |____ \____
prompt .
prompt . Application Express Runtime Installation.
prompt .........................................................


set define '^'
set concat on
set concat .
set verify off
set termout off
spool off
set termout on


prompt Install Application Express applications
begin
    wwv_flow_security.g_security_group_id := 10;
end;
/
@@f4411_zh-cn.sql
@@f4155_zh-cn.sql

prompt Adjust instance settings
-- Update image prefix, owner, release of installed translated applications
begin
    wwv_flow_security.g_security_group_id := 10;
    --
    for c1 in (select flow_image_prefix, owner
                 from wwv_flows
                where security_group_id = 10
                  and id = 4155) loop
        update wwv_flows
           set flow_image_prefix = c1.flow_image_prefix,
               owner = c1.owner,
               flow_version = (select '&PRODUCT_NAME. ' || wwv_flows_release from dual where rownum = 1)
         where id in (4161,4417);
        commit;
        exit;
    end loop;--c1
end;
/