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

    Receive notifications and find solutions for new or common issues

    Get summarized answers and video solutions from our new AI chatbot.

    Download the Esri Support App

    Discover more on this topic

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options