Announcement Announcement Module
Collapse
No announcement yet.
ORA-00932: inconsistent datatypes: expected MDSYS.SDO_GEOMETRY got CHAR Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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

    insertIntoTable is of type new SimpleJdbcInsert(getDataSource()).withTableName(TA BLE_NAME)

    insertIntoTable.execute(map);//code that is doing the insertion

    map has the (key,value) pairs for (column name, column value)
    ,and shown below is the ADDRESS column 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? Any direction is appreciated.

    Thanks..
    J

  • #2
    Hello,
    Sorry to bother you but did you ever get an answer/solution to this?

    Thx. in advance.

    Comment

    Working...
    X