K2InformaticsGmbH / erloci

Erlang Oracle native driver - DEPRECATED, see https://github.com/K2InformaticsGmbH/oranif instead
Apache License 2.0
37 stars 11 forks source link

Error reading CLOB in logger_log #65

Closed acautin closed 5 years ago

acautin commented 5 years ago

From console.

[error] [_DDRL_] {c_src/erloci_lib/ocistmt.cpp:rows:930} failed OCILobGetLength
 for 0x7fad0f8b59f8 row 1 column 13 reason [rows:928] Error - OCI_INVALID_HANDLE
 (select SCOTT.LOGGER_LOGS.*, SCOTT.LOGGER_LOGS.ROWID from SCOTT.LOGGER_LOGS)
[error] [_DDRL_] {dderl_fsm,1218} Error on fsm <0.5860.0> when State filling
 Message:  {0,<<"[rows:928] Error - OCI_INVALID_HANDLE\n">>}
acautin commented 5 years ago

It is possible to reproduce this error by reading an null CLOB, example:

create table testclob (id int, someclobtest clob)
insert into testclob values(1, NULL)