DatabaseProcApplicationCreatedLinks
sybsystemprocssp_drv_locator_to_text  14 déc. 14Defects Propagation Dependencies

1     
2     
3     /*
4     * BEGIN LOCATOR HELPER
5     */
6     
7     CREATE OR REPLACE PROCEDURE sp_drv_locator_to_text(@locator TEXT_LOCATOR) AS BEGIN SELECT return_lob(TEXT, @locator) END
8     


exec sp_procxmode 'sp_drv_locator_to_text', 'AnyMode'
go

Grant Execute on sp_drv_locator_to_text to public
go
RESULT SETS
sp_drv_locator_to_text_rset_001

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

DATA PROPAGATION detailed
ColumnWritten To
@locatorsp_drv_locator_to_text_rset_001.sqlbNoName38

DEPENDENCIES
PROCS AND TABLES USED
writes table sybsystemprocs..sp_drv_locator_to_text_rset_001