[gdal-dev] how to INSERT INTO USER_SDO_GEOM_METADATA with OGR

[Clay, Bruce]

I am working on a program that uses GDAL / OGR to copy data from an ESRI
/ SDE database table stored on ORACLE into an SDO_GEOMETRY supported
table.  The program will also load CSV and shapefiles into SDO_GEOMETRY
supported tables.  It looks like I need to add a table to the
USER_SDO_GEOM_METADATA before I can register the SDO_GEOMETRY enabled
table with SDE to make it usable in ArcMap.

 

The SQL command I need to execute starts with "INSERT INTO
USER_SDO_GEOM_METADATA".  It looks like ogrDataSource ExecuteSql only
supports "CREATE INDEX", "DROP INDEX" and select functions and blocks
any INSERT or UPDATE calls.

 

Interestingly OGROCIDataSource::DeleteLayer sends a "DELETE FROM
USER_SDO_GEOM_METADATA" but I down't see anyplace that it calls the
insert.

 

The data appears to be copied from the SDE table to the OCI table but
ArcCatalog crashes trying to register the table.

 

Is there any way to get other SQL functions to pass through ExecuteSql
to support this insertion?

 

Is there a way to reach directly into the OCI data source driver
ExecuteSql?

 

 

Bruce

 

 

 




This message and any enclosures are intended only for the addressee.  Please  
notify the sender by email if you are not the intended recipient.  If you are  
not the intended recipient, you may not use, copy, disclose, or distribute this  
message or its contents or enclosures to any other person and any such actions  
may be unlawful.  Ball reserves the right to monitor and review all messages  
and enclosures sent to or from this email address.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20080423/988f8b75/attachment.html