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!

Unsupported Oracle Data Type USERDEFINED encountered

686349Feb 20 2009 — edited Feb 23 2009

How can I create a select from Visual Studio 2008 when my column type is MDSYS.SDO_GEOMETRY.

My table structure:
CREATE TABLE "FAKATASZTER_TURKALO"."FA"
( "FID" NUMBER(10,0),
"GEOM" "MDSYS"."SDO_GEOMETRY" , ...

This select is working fine in Oralce SQL Developer:

select FAKATASZTER_TURKALO.FA.GEOM from FAKATASZTER_TURKALO.FA;
Result:

MDSYS.SDO_GEOMETRY(2001,23700,MDSYS.SDO_POINT_TYPE(16775.578,589445.405,null),null,null)

In Visual Studio, I'm create a new data connection with DataSource Connection Wizard. I can connect to the database, I see the the tables, I can select except MDSYS.SDO_GEOMETRY coulmn type. When I try to select this column I got an error: Unsupported Oracle Data Type USERDEFINED encountered.
Please helop me.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 23 2009

Added on Feb 20 2009

#database-key-features, #spatial

3 comments

4,996 views