Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00932: inconsistent datatypes: expected MDSYS.SDO_GEOMETRY got CHAR

780862Aug 2 2010 — edited Aug 3 2010
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 31 2010
Added on Aug 2 2010
5 comments
5,679 views