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