Database | Proc | Application | Created | Links |
sybsystemprocs | sp_jdbc_lob_length | 31 Aug 14 | Defects 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 |