DatabaseProcApplicationCreatedLinks
sybsystemprocssp_jdbc_lob_length  31 Aug 14Defects Dependencies

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


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 9
 PERR 6 Parsing Error Could not find COLUMN TEXT_locator in the query's tables 11
 PERR 6 Parsing Error Could not find COLUMN UNITEXT_locator in the query's tables 13
 MGTP 3 Grant to public sybsystemprocs..sp_jdbc_lob_length  
 MUCO 3 Useless Code Useless Brackets in create proc 3
 QAFM 3 Var Assignment from potentially many rows 9
 QAFM 3 Var Assignment from potentially many rows 11
 QAFM 3 Var Assignment from potentially many rows 13
 MTR1 2 Metrics: Comments Ratio Comments: 5% 3
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 3 = 2dec - 1exi + 2 3
 MTR3 2 Metrics: Query Complexity Complexity: 8 3

DEPENDENCIES