DatabaseProcApplicationCreatedLinks
sybsystemprocssp_ijdbc_jar_for_class  31 Aug 14Defects Dependencies

1     
2     /*
3     **  sp_ijdbc_jar_for_class
4     */
5     
6     create procedure sp_ijdbc_jar_for_class(
7         @class_name varchar(255))
8     as
9     
10        delete #tmp_jar_for_class
11    
12        insert #tmp_jar_for_class
13        select
14            sj.jbinary
15        from
16            sysjars sj, sysxtypes sjc
17        where
18            sjc.xtname = @class_name and sj.jid = sjc.xtcontainer
19    
20    
21    


exec sp_procxmode 'sp_ijdbc_jar_for_class', 'AnyMode'
go

Grant Execute on sp_ijdbc_jar_for_class to public
go
DEFECTS
 MINU 4 Unique Index with nullable columns sybsystemprocs..sysjars sybsystemprocs..sysjars
 MINU 4 Unique Index with nullable columns sybsystemprocs..sysxtypes sybsystemprocs..sysxtypes
 MGTP 3 Grant to public sybsystemprocs..sp_ijdbc_jar_for_class  
 MGTP 3 Grant to public sybsystemprocs..sysjars  
 MGTP 3 Grant to public sybsystemprocs..sysxtypes  
 MNER 3 No Error Check should check @@error after delete 10
 MNER 3 No Error Check should check @@error after insert 12
 MUCO 3 Useless Code Useless Brackets in create proc 6
 QNAJ 3 Not using ANSI Inner Join 15
 MTR1 2 Metrics: Comments Ratio Comments: 5% 6
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 1 = 0dec - 1exi + 2 6
 MTR3 2 Metrics: Query Complexity Complexity: 9 6
 PRED_QUERY_COLLECTION 2 {j=sybsystemprocs..sysjars, x=sybsystemprocs..sysxtypes} 0 13

DEPENDENCIES
PROCS AND TABLES USED
reads table sybsystemprocs..sysjars  
writes table tempdb..#tmp_jar_for_class (1) 
reads table sybsystemprocs..sysxtypes