ORA-00932: inconsistent datatypes: expected MDSYS.SDO_GEOMETRY got CHAR
780862Aug 2 2010 — edited Aug 3 2010I am using Spring JDBC template in inserting into a table that has a SDO_GEOMETRY data type.
However, I am getting the following error:
ORA-00932: inconsistent datatypes: expected MDSYS.SDO_GEOMETRY got CHAR
-------------
Java,Spring
-------------
insertIntoTable.execute(map);
my map has the column, value key value pairs, and shown below is for the ADDRESS which is of SDO_GEOMETRY type:
parameters.put("ADDRESS ", "MDSYS.SDO_GEOMETRY(2001,8307,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1,1)," +
"MDSYS.SDO_ORDINATE_ARRAY("+getLongitude()+
","+getLatitude()+" ))");
Did anyone have this problem before?
Thanks..
J