SDO_GEOM.SDO_BUFFER receive ORA-00932:inconsistent datatypes
Hi,
When i perform the 10g spatial function SDO_GEOM.SDO_BUFFER i receive ORA-00932: inconsistent datatypes
ORA-00932: inconsistent datatypes: expected an IN argument at postion 1 that is an instance of an Oracle type convertible to an instance of a user
defined Java class got an exception while converting to the user class
here two sql query. one on table with metadata and spatial index, other as computed geometry.
select SDO_GEOM.SDO_BUFFER(trg.geom, 10, 0.005) geom_buffer
from s716_tra_geoms trg
where trg.geom is not null
and SDO_GEOM.validate_geometry(trg.geom,0.005) = 'TRUE'
and rownum = 1;
with qry as
When i perform the 10g spatial function SDO_GEOM.SDO_BUFFER i receive ORA-00932: inconsistent datatypes
ORA-00932: inconsistent datatypes: expected an IN argument at postion 1 that is an instance of an Oracle type convertible to an instance of a user
defined Java class got an exception while converting to the user class
here two sql query. one on table with metadata and spatial index, other as computed geometry.
select SDO_GEOM.SDO_BUFFER(trg.geom, 10, 0.005) geom_buffer
from s716_tra_geoms trg
where trg.geom is not null
and SDO_GEOM.validate_geometry(trg.geom,0.005) = 'TRUE'
and rownum = 1;
with qry as
0