Database | Proc | Application | Created | Links |
sybsystemprocs | sp_ijdbc_classes_in_jar | 31 Aug 14 | Defects Dependencies |
1 2 /* 3 ** sp_ijdbc_classes_in_jar 4 */ 5 6 create procedure sp_ijdbc_classes_in_jar( 7 @jar_name varchar(255)) 8 as 9 10 delete #tmp_classes_in_jar 11 12 insert #tmp_classes_in_jar 13 select 14 sjc.xtname 15 from 16 sysjars sj, sysxtypes sjc 17 where 18 sj.jid = sjc.xtcontainer and sj.jname = @jar_name 19
exec sp_procxmode 'sp_ijdbc_classes_in_jar', 'AnyMode' go Grant Execute on sp_ijdbc_classes_in_jar 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_classes_in_jar | |
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: 6% | 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 writes table tempdb..#tmp_classes_in_jar (1) reads table sybsystemprocs..sysxtypes reads table sybsystemprocs..sysjars |