DatabaseProcApplicationCreatedLinks
sybsystemprocssp_ijdbc_class_for_name  31 Aug 14Defects 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