Skip to Main Content
Forums

SQL Developer

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!

Database copy of a SDO_GEOMETRY column fails in SQL Developer 3.2.20.09

user10768987Apr 11 2013 — edited May 3 2013
I'm trying to copy a table that has a SDO_GEOMETRY column and it just fails:

Moving Data for object LOCATION
Unable to perform batch insert.
LOCATION ORA-00932: inconsistent datatypes: expected MDSYS.SDO_GEOMETRY got CHAR


What's the workaround for this or SQL Developer doesn't support this?

Edited by: user10768987 on Apr 11, 2013 11:05 AM

Comments

user10768987
Still have the problem... Seems to be a bug in SQL Developer?
unknown-7404
Welcome to the forum!

Whenever you post provide your full version number for Sql Developer and, if a database is involved the name and full version of the DB.
>
I'm trying to copy a table that has a SDO_GEOMETRY column and it just fails:

Moving Data for object LOCATION
Unable to perform batch insert.
LOCATION ORA-00932: inconsistent datatypes: expected MDSYS.SDO_GEOMETRY got CHAR

What's the workaround for this or SQL Developer doesn't support this?
>
Since you haven't posted your version and provided the exact steps you are using we have no idea what you are doing to try to copy a table.
thatJeffSmith-Oracle
I was able to reproduce this with OE.CUSTOMERS.

Do we support this - yes.

Bug 16761538

Edited by: Jeff Smith SQLDev PM on May 3, 2013 10:38 AM
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 31 2013
Added on Apr 11 2013
#developer, #spatial, #sql, #sql-developer
3 comments
643 views