DatabaseProcApplicationCreatedLinks
sybsystemprocssp_drv_text_substring  31 Aug 14Defects Dependencies

1     CREATE PROCEDURE sp_drv_text_substring(@locator TEXT_LOCATOR, @start INT, @length INT) AS BEGIN
2             SELECT return_lob(TEXT, substring(@locator, @start, @length))
3         END
4     


exec sp_procxmode 'sp_drv_text_substring', 'AnyMode'
go

Grant Execute on sp_drv_text_substring to public
go
RESULT SETS
sp_drv_text_substring_rset_001

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

DEPENDENCIES