DatabaseProcApplicationCreatedLinks
sybsystemprocssp_inst15015msg  14 déc. 14Defects Propagation Dependencies

1     
2     
3     /*
4     ** SP_INST15015MSG
5     **
6     ** Description:
7     **
8     */
9     create or replace procedure sp_inst15015msg
10    as
11        begin -- {
12    
13            exec sp_inst15015msg_config
14    
15            dump tran master with truncate_only
16    
17            exec sp_inst15015msg_all_us_mesgs
18    
19            dump tran master with truncate_only
20    
21            exec sp_inst15015msg_all_oth_mesgs
22    
23            dump tran master with truncate_only
24    
25            return
26    
27        end -- }
28    

DEFECTS
 MNER 3 No Error Check should check return value of exec 13
 MNER 3 No Error Check should check return value of exec 17
 MNER 3 No Error Check should check return value of exec 21
 MUCO 3 Useless Code Useless Begin-End Pair 11
 MTR1 2 Metrics: Comments Ratio Comments: 10% 9
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 1dec - 1exi + 2 9
 MTR3 2 Metrics: Query Complexity Complexity: 8 9

DEPENDENCIES
PROCS AND TABLES USED
calls proc sybsystemprocs..sp_inst15015msg_config  
calls proc sybsystemprocs..sp_inst15015msg_all_oth_mesgs  
   calls proc sybsystemprocs..sp_inst15015msg_oth_mesg  
      calls proc sybsystemprocs..sp_inst15015msg_addlimsg  
         read_writes table master..sysmessages (1)  
      reads table master..syslanguages (1)  
calls proc sybsystemprocs..sp_inst15015msg_all_us_mesgs  
   calls proc sybsystemprocs..sp_inst15015msg_us_mesg  
      read_writes table master..sysmessages (1)  

CALLERS
called by proc sybsystemprocs..sp_downgrade