1 PACKAGE BODY MSD_AW_LOADER AS
2 /* $Header: msdawldb.pls 120.2 2005/11/02 11:41 ziahmed noship $ */
3
4 /* Public Procedures */
5
6 procedure attach_code_aw is
7 begin
8 -- attach ODPCODE rw, create it if it does not exist
9 -- dbms_aw.execute('awwaittime = 1000000; &(if aw(attached ''ODPCODE'') then ''shw NA'' else ''aw attach ODPCODE rw wait'')');
10 dbms_aw.AW_ATTACH('ODPCODE',true,true,'wait');
11 end attach_code_aw;
12
13 procedure update_code_aw is
14 begin
15 -- Issue an update if _noupdate flag is not set
16 dbms_aw.execute('&(if exists(''_noupdate'') then ''shw na'' else ''upd'')');
17 end update_code_aw;
18
19 END MSD_AW_LOADER;