Query Layers - Geometry not drawing from Oracle Spatial

ChrisBeaudette — Thu, 11 Oct 2012 15:26:38 GMT

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

Thanks,

Chris

Re: Query Layers - Geometry not drawing from Oracle Spatial

BenLin — Mon, 29 Oct 2012 21:32:00 GMT

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.

topic Query Layers - Geometry not drawing from Oracle Spatial in Data Management Questions

Query Layers - Geometry not drawing from Oracle Spatial

Re: Query Layers - Geometry not drawing from Oracle Spatial