DatabaseProcApplicationCreatedLinks
sybsystemprocssp_jdbc_jar_by_name  14 déc. 14Defects Propagation Dependencies

1     
2     create or replace procedure sp_jdbc_jar_by_name(
3         @jar_name varchar(255))
4     as
5         select
6             sj.jbinary
7         from
8             sysjars sj
9         where
10            jname = @jar_name
11    


exec sp_procxmode 'sp_jdbc_jar_by_name', 'AnyMode'
go

Grant Execute on sp_jdbc_jar_by_name to public
go
RESULT SETS
sp_jdbc_jar_by_name_rset_001

DEFECTS
 MINU 4 Unique Index with nullable columns sybsystemprocs..sysjars sybsystemprocs..sysjars
 MGTP 3 Grant to public sybsystemprocs..sp_jdbc_jar_by_name  
 MGTP 3 Grant to public sybsystemprocs..sysjars  
 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..sysjars  
writes table sybsystemprocs..sp_jdbc_jar_by_name_rset_001