DatabaseProcApplicationCreatedLinks
sybsystemprocssp_ijdbc_jar_by_name  31 Aug 14Defects Dependencies

1     
2     /*
3     **  sp_ijdbc_jar_by_name
4     */
5     
6     create procedure sp_ijdbc_jar_by_name(
7         @jar_name varchar(255))
8     as
9     
10        delete #tmp_jar_by_name
11    
12        insert #tmp_jar_by_name
13        select
14            sj.jbinary
15        from
16            sysjars sj
17        where
18    
19            jname = @jar_name
20    


exec sp_procxmode 'sp_ijdbc_jar_by_name', 'AnyMode'
go

Grant Execute on sp_ijdbc_jar_by_name to public
go
DEFECTS
 MINU 4 Unique Index with nullable columns sybsystemprocs..sysjars sybsystemprocs..sysjars
 MGTP 3 Grant to public sybsystemprocs..sp_ijdbc_jar_by_name  
 MGTP 3 Grant to public sybsystemprocs..sysjars  
 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
 MTR1 2 Metrics: Comments Ratio Comments: 10% 6
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 1 = 0dec - 1exi + 2 6
 MTR3 2 Metrics: Query Complexity Complexity: 7 6

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