Invalid LOB locator specified | IFS Community

Invalid LOB locator specified

  • 14 July 2022
  • 2 replies

Userlevel 1
Badge +1

Anyone that can shade some light on…



I get the error trying to run a (scheduled) report for a particular account.

2 replies

Userlevel 1
Badge +1

Hello community. Has anyone had any luck?

Userlevel 7
Badge +14

You better check any CLOB code  in the report logic with texts exceeding 32KB.

CLOB is something like a file handle. Therefore Oracle calls it sometimes a lob locator. It must either point into table's data segment(lob segment) or to a temporary tablespace. LOBs can have up to 176TB, therefore they can not be kept in database server RAM.

Sometimes implicit conversion from/to VARCHAR2 works, so it might seem that CLOB is variable like any other.