DatabaseProcApplicationCreatedLinks
sybsystemprocssp_jdbc_class_for_name  31 Aug 14Defects Dependencies

1     /** SECTION END: CLEANUP **/
2     
3     create procedure sp_jdbc_class_for_name(
4         @class_name varchar(255))
5     as
6         select
7             xtbinaryoffrow
8         from
9             sysxtypes
10        where
11            xtname = @class_name
12    
13    


exec sp_procxmode 'sp_jdbc_class_for_name', 'AnyMode'
go

Grant Execute on sp_jdbc_class_for_name to public
go
RESULT SETS
sp_jdbc_class_for_name_rset_001

DEFECTS
 MINU 4 Unique Index with nullable columns sybsystemprocs..sysxtypes sybsystemprocs..sysxtypes
 MGTP 3 Grant to public sybsystemprocs..sp_jdbc_class_for_name  
 MGTP 3 Grant to public sybsystemprocs..sysxtypes  
 MUCO 3 Useless Code Useless Brackets in create proc 3
 MRST 2 Result Set Marker 6
 MTR1 2 Metrics: Comments Ratio Comments: 12% 3
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 1 = 0dec - 1exi + 2 3
 MTR3 2 Metrics: Query Complexity Complexity: 4 3

DEPENDENCIES
PROCS AND TABLES USED
reads table sybsystemprocs..sysxtypes