DatabaseProcApplicationCreatedLinks
sybsystemprocssp_jdbc_lob_length  14 déc. 14Defects Propagation Dependencies

1     
2     
3     /*
4     **  sp_jdbc_lob_length 
5     */
6     
7     create or replace procedure sp_jdbc_lob_length(
8         @lob_type int,
9         @locator binary(24),
10        @result bigint output)
11    as
12        if @lob_type = 0
13            select @result = datalength(locator_literal(IMAGE_locator, @locator))
14        else if @lob_type = 1
15            select @result = char_length(locator_literal(TEXT_locator, @locator))
16        else
17            select @result = char_length(locator_literal(UNITEXT_locator, @locator))
18    


exec sp_procxmode 'sp_jdbc_lob_length', 'AnyMode'
go

Grant Execute on sp_jdbc_lob_length to public
go
DEFECTS
 PERR 6 Parsing Error Could not find COLUMN IMAGE_locator in the query's tables 13
 PERR 6 Parsing Error Could not find COLUMN TEXT_locator in the query's tables 15
 PERR 6 Parsing Error Could not find COLUMN UNITEXT_locator in the query's tables 17
 MGTP 3 Grant to public sybsystemprocs..sp_jdbc_lob_length  
 MUCO 3 Useless Code Useless Brackets in create proc 7
 QAFM 3 Var Assignment from potentially many rows 13
 QAFM 3 Var Assignment from potentially many rows 15
 QAFM 3 Var Assignment from potentially many rows 17
 MTR1 2 Metrics: Comments Ratio Comments: 5% 7
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 4 = 3dec - 1exi + 2 7
 MTR3 2 Metrics: Query Complexity Complexity: 8 7

DEPENDENCIES