DatabaseProcApplicationCreatedLinks
sybsystemprocssp_drv_create_text_locator  14 déc. 14Defects Propagation Dependencies

1     
2     
3     CREATE OR REPLACE PROCEDURE sp_drv_create_text_locator(@value TEXT = NULL) AS BEGIN SELECT CREATE_LOCATOR(TEXT_LOCATOR, @value) END
4     


exec sp_procxmode 'sp_drv_create_text_locator', 'AnyMode'
go

Grant Execute on sp_drv_create_text_locator to public
go
RESULT SETS
sp_drv_create_text_locator_rset_001

DEFECTS
 PERR 6 Parsing Error Could not find COLUMN TEXT_LOCATOR in the query's tables 3
 MGTP 3 Grant to public sybsystemprocs..sp_drv_create_text_locator  
 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 CREATE_LOCATOR(TEXT_LOCATOR, @value) 3
 MRST 2 Result Set Marker 3
 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
@valuesp_drv_create_text_locator_rset_001.sqlbNoName75

DEPENDENCIES
PROCS AND TABLES USED
writes table sybsystemprocs..sp_drv_create_text_locator_rset_001