ERROR

ORA-22275: invalid LOB locator specified

Last Published: April 25, 2020

Error Message

On all ST_*FromWKB functions on all Oracle 9i platforms, the following error is returned:

Code:
SQL> select dbms_lob.getlength(SDE.ST_AsBinary(SDE.ST_Point('point empty', 1000))) from dual;
select dbms_lob.getlength(SDE.ST_AsBinary(SDE.ST_Point('point empty', 1000))) from dual
*
ERROR at line 1:
ORA-22275: invalid LOB locator specified
ORA-06512: at "SYS.DBMS_LOB", line 535

Cause

Oracle 9i implementation has a problem dealing with empty geometry. This problem was detected in ArcSDE for Oracle version 9.2.

Solution or Workaround

This is a known issue, but there is currently no workaround.

    Article ID:000010020

    Software:
    • Legacy Products

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Discover more on this topic