Question

Invalid LOB locator specified

  • 14 July 2022
  • 3 replies
  • 260 views

Userlevel 1
Badge +6

Anyone that can shade some light on…

 

 

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


3 replies

Userlevel 1
Badge +6

Hello community. Has anyone had any luck?

Badge +15

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.

 

 

Userlevel 6
Badge +15

@mpmysight you may wanna check below post also. Maybe it’s not applicable in your case as you’re using a custom C_% RPI package.

 

Reply