DatabaseProcApplicationCreatedLinks
sybsystemprocssp_drv_image_substring  14 déc. 14Defects Propagation Dependencies

1     
2     
3     CREATE OR REPLACE PROCEDURE sp_drv_image_substring(@locator IMAGE_LOCATOR, @start INT, @length INT) AS BEGIN
4             SELECT return_lob(IMAGE, substring(@locator, @start, @length))
5         END
6     


exec sp_procxmode 'sp_drv_image_substring', 'AnyMode'
go

Grant Execute on sp_drv_image_substring to public
go
RESULT SETS
sp_drv_image_substring_rset_001

DEFECTS
 PERR 6 Parsing Error Could not find COLUMN IMAGE in the query's tables 4
 MGTP 3 Grant to public sybsystemprocs..sp_drv_image_substring  
 MUCO 3 Useless Code Useless Begin-End Pair 3
 MUCO 3 Useless Code Useless Brackets in create proc 3
 QNAM 3 Select expression has no name return_lob(IMAGE, substring(@locator, @start, @length)) 4
 MRST 2 Result Set Marker 4
 MTR1 2 Metrics: Comments Ratio Comments: 0% 3
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 1dec - 1exi + 2 3
 MTR3 2 Metrics: Query Complexity Complexity: 2 3

DATA PROPAGATION detailed
ColumnWritten To
@lengthsp_drv_image_substring_rset_001.sqlbNoName68
@locatorsp_drv_image_substring_rset_001.sqlbNoName68
@startsp_drv_image_substring_rset_001.sqlbNoName68

DEPENDENCIES
PROCS AND TABLES USED
writes table sybsystemprocs..sp_drv_image_substring_rset_001