Query Layers - Geometry not drawing from Oracle Spatial

[ChrisBeaudette]

We are having the exact problem posted at this thread from the 'Desktop General' forum.  Thought this forum might have insights.

Thanks,

Chris

[BenLin]

Hi Chris,

Not sure if you have already resolved the issue or not. Could you please post your SDO table DDL syntax here? Like:

SQL> conn test/test@mydb
SQL> set long 999999
SQL> set head off
SQL> SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name)
     FROM USER_TABLES u where u.table_name = 'STREETS_SDO';
SQL> set head on
SQL> select distinct a.shape.sdo_gtype from test.streets_sdo a;
SQL> select distinct a.shape.sdo_srid from test.streets_sdo a;
SQL> select * from user_sdo_geom_metadata where table_name = 'STREETS_SDO';

Thanks,
Ben L.