Database | Proc | Application | Created | Links |
sybsystemprocs | sp_ijdbc_jar_by_name | 31 Aug 14 | Defects 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 |