Database | Proc | Application | Created | Links |
sybsystemprocs | sp_ijdbc_class_for_name | 31 Aug 14 | Defects Dependencies |
1 2 /* 3 ** sp_ijdbc_class_for_name 4 */ 5 6 create procedure sp_ijdbc_class_for_name( 7 @class_name varchar(255)) 8 as 9 10 delete #tmp_class_for_name 11 12 insert #tmp_class_for_name 13 select 14 xtbinaryoffrow 15 from 16 sysxtypes 17 where 18 xtname = @class_name 19 20 21 22 23
exec sp_procxmode 'sp_ijdbc_class_for_name', 'AnyMode' go Grant Execute on sp_ijdbc_class_for_name to public go
DEFECTS | |
MINU 4 Unique Index with nullable columns sybsystemprocs..sysxtypes | sybsystemprocs..sysxtypes |
MGTP 3 Grant to public sybsystemprocs..sp_ijdbc_class_for_name | |
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 |
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: 7 | 6 |
DEPENDENCIES |
PROCS AND TABLES USED writes table tempdb..#tmp_class_for_name (1) reads table sybsystemprocs..sysxtypes |