[Gdal-dev] OCI-Import

[Stephan Holl]

Hello Frank, 

thanks for your quick response.

On Wed, 4 Jan 2006 10:28:05 -0500 Frank Warmerdam <warmerdam at pobox.com>
wrote:

> On 1/4/06, Stephan Holl <sholl at gmx.net> wrote:
> > I was also told, that this results from the initial CREATE TABLE
> > statement, which was done by OGR, where the attribute-columns
> > were enclosed in quotes, something like this:
> >
> > create table dataset (
> >      OGR_FID number(38),
> >      ORA_GEOMETRY MDSYS.SDO_GEOMETRY,
> >      "cat" number(38),
> >      "column" number(38),
> >      [...]
> >   ..... ) storage (...) tablespace ... ;
> >
> > For a select-statement the columns needs to be in quotes as well,
> > otherwise Oracle does not recognize the column-name correct.
> >
> > Is this a bug or a feature? Does anybody can give me a hint how to
> > get arround this?
> 
> Stepan,
> 
> I suspect the problem is that lower case field names are
> being preserved by the quoting of the field name when they
> are created (in OGROCIWritableLayer::CreateField()s
> ALTER TABLE command.
> 
> If this is the issue, then I think a reasonable solution would
> be to launder lower case names to upper, either all the time
> in CreateField(), or perhaps only when the layer creation option
> "LAUNDER" is set true.
> 
> Are you building from source?  If so, I could try committing a
> change to do this, and you could test it.

I could build from source and have a quick test, if you let me know,
which sollution you prefered (LCO-option or all the time).

Best regards

	Stephan

-- 
Stephan Holl

Check headers for GnuPG Key!
http://www.gdf-hannover.de

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/gdal-dev/attachments/20060104/55b76dda/signature.bin