English

Error: ORA-22275: invalid LOB locator specified

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.