[gdal-dev] Query regarding results from ExecuteSQL and the OCI driver - pre OGR 1.8.n

[Peter J Halls]

Dear Team,

     I'm waiting for 1.8 to be firmed up before upgrading to it, so this relates 
to the old OCI driver.

     I'm puzzled.  In order to work around the possibility that a table may not 
exist, and therefore require to be created, I attempted to use ExecuteSQL 
through the OCI driver with the SQL expression
"Select * from user_catalog where table_name like '<required table>'"

     The call returns a non-zero value, but when treating this as a layerhandle 
and looking to check that the layer name is that requested I find the results of 
  OGR_FD_GetName are the text of my original SQL query.  Looking at the code in 
ogrocidatasource I can see no apparent reason for this result.

     Am I going about my query incorrectly?  Should I be expecting to obtain a 
valid layer from this query or is a non-zero return value adequate indication 
that the result of the query contains one or more table names?

Thanks and best wishes,

Peter

--------------------------------------------------------------------------------
Peter J Halls, GIS Advisor, University of York
Telephone: 01904 323806     Fax: 01904 323740
Snail mail: IT Services, University of York, Heslington, York YO10 5DD
This message has the status of a private and personal communication
--------------------------------------------------------------------------------