1 /** SECTION END: CLEANUP **/
2
3 create procedure sp_jdbc_lob_getbytes(
4 @lob_type int,
5 @locator binary(24),
6 @read_pos bigint,
7 @read_len int)
8 as
9 if @lob_type = 0
10 select substring(locator_literal(IMAGE_locator, @locator), @read_pos, @read_len), datalength(locator_literal(IMAGE_locator, @locator))
11 else if @lob_type = 1
12 select substring(locator_literal(TEXT_locator, @locator), @read_pos, @read_len), char_length(locator_literal(TEXT_locator, @locator))
13 else
14 select substring(locator_literal(UNITEXT_locator, @locator), @read_pos, @read_len), char_length(locator_literal(UNITEXT_locator, @locator))
15
exec sp_procxmode 'sp_jdbc_lob_getbytes', 'AnyMode'
go
Grant Execute on sp_jdbc_lob_getbytes to public
go
| DEFECTS |
 PERR 6 Parsing Error Could not find COLUMN IMAGE_locator in the query's tables |
10 |
| PERR 6 Parsing Error Could not find COLUMN TEXT_locator in the query's tables |
12 |
| PERR 6 Parsing Error Could not find COLUMN UNITEXT_locator in the query's tables |
14 |
 MGTP 3 Grant to public sybsystemprocs..sp_jdbc_lob_getbytes |
|
| MUCO 3 Useless Code Useless Brackets in create proc |
3 |
| QCRS 3 Conditional Result Set |
10 |
| QCRS 3 Conditional Result Set |
12 |
| QCRS 3 Conditional Result Set |
14 |
| QNAM 3 Select expression has no name datalength(locator_literal(IMAGE_locator, @locator)) |
10 |
| QNAM 3 Select expression has no name substring(locator_literal(IMAGE_locator, @locator), @read_pos, @read_len) |
10 |
| QNAM 3 Select expression has no name char_length(locator_literal(TEXT_locator, @locator)) |
12 |
| QNAM 3 Select expression has no name substring(locator_literal(TEXT_locator, @locator), @read_pos, @read_len) |
12 |
| QNAM 3 Select expression has no name char_length(locator_literal(UNITEXT_locator, @locator)) |
14 |
| QNAM 3 Select expression has no name substring(locator_literal(UNITEXT_locator, @locator), @read_pos, @read_len) |
14 |
 MRST 2 Result Set Marker |
10 |
| MRST 2 Result Set Marker |
12 |
| MRST 2 Result Set Marker |
14 |
| MTR1 2 Metrics: Comments Ratio Comments: 3% |
3 |
| MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 3 = 2dec - 1exi + 2 |
3 |
| MTR3 2 Metrics: Query Complexity Complexity: 8 |
3 |
