English

Error: ORA-00932: inconsistent datatypes: expected SDE.ST_GEOMETRY got MDSYS.ST_POINT

Error Message

If the st_geometry type or operators are not fully qualified with the SDE owner and Oracle spatial is installed in the Oracle database, the following Oracle error will be encountered:

"ORA-00932: inconsistent datatypes: expected SDE.ST_GEOMETRY got MDSYS.ST_POINT."

Code:
SQL> INSERT INTO manholes (objectid, shape)
2 VALUES (1024, st_point('1395754.752 405415.412',4));
VALUES (1024, st_point('1395754.752 405415.412',4))
*
ERROR at line 2:
ORA-00932: inconsistent datatypes: expected SDE.ST_GEOMETRY got MDSYS.ST_POINT

Cause

If the st_geometry operator is not fully qualified when public synonyms for the st_geometry type and operators do not exist, and Oracle spatial is installed in the Oracle database, Oracle maps st_geometry operators to its own st_geometry type owned by the MDSYS user.

Solution or Workaround

Always fully qualify all st_geometry operators with the type and operator owner SDE, for example, sde.st_point or sde.st_intersects.

    Related Information