DatabaseProcApplicationCreatedLinks
sybsystemprocssp_jdbc_class_for_name  14 déc. 14Defects Propagation Dependencies

1     
2     create or replace procedure sp_jdbc_class_for_name(
3         @class_name varchar(255))
4     as
5         select
6             xtbinaryoffrow
7         from
8             sysxtypes
9         where
10            xtname = @class_name
11    
12    


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 2
 MRST 2 Result Set Marker 5
 MTR1 2 Metrics: Comments Ratio Comments: 0% 2
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 1dec - 1exi + 2 2
 MTR3 2 Metrics: Query Complexity Complexity: 4 2

DEPENDENCIES
PROCS AND TABLES USED
reads table sybsystemprocs..sysxtypes  
writes table sybsystemprocs..sp_jdbc_class_for_name_rset_001