problem with ogr oracle spatial layer

[Mark Adams]

Yikes. Can you give any pointers as to what I should be looking at? In
terms of setting up the environment, all I've done is install the Oracle
9i client on the web server, and mapserver/mapscript with a version of
gdal compiled with the ogr_oci dll as a plugin. To have the plugin
recognized I set the GDAL_DRIVER_PATH variable (until then ogrinfo
didn't recognize OCI as a supported format) to the Windows\system32
folder where this dll resides.

What do you mean by other OCI client programs? Oracle client itself has
no troubles connecting to the database. Also, 2083788472 doesn't look
like an Oracle error code? (Aren't they usually "ORA-XXXXX"?)

Thanks.

------------------------------
Mark Adams
Senior Analyst & Project Manager
Cuesta Systems (DPRA Canada)
5230 South Service Road
Burlington, ON L7L 5K2
Phone: 905-333-4544 x14
Fax: 905-333-0455
Email: mark.adams at dpra.com


-----Original Message-----
From: Frank Warmerdam [mailto:fwarmerdam at gmail.com] On Behalf Of Frank
Warmerdam
Sent: June 6, 2006 9:36 PM
To: Mark Adams
Cc: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: Re: [UMN_MAPSERVER-USERS] problem with ogr oracle spatial layer

Mark Adams wrote:
> OCI: OCIEnvCreate() failed with status 2083788472.
> 
> Presumably Oracle is not properly installed, skipping.

Mark,

Based on this, I would say the problem is not with your connection
string or something later.  But rather is somehow related to the
version of libraries being used.  This error message is produced by
the following code:

     if( ghOracleEnvironment == NULL )
     {
         nStatus =
             OCIEnvCreate( &ghOracleEnvironment, OCI_OBJECT, (dvoid *)0,
                           0, 0, 0, (size_t) 0, (dvoid **)0 );

         if( nStatus == -1 || ghOracleEnvironment == NULL )
         {
             CPLDebug("OCI",
                      "OCIEnvCreate() failed with status %d.\n"
                      "Presumably Oracle is not properly installed,
skipping.");

             return FALSE;
         }
     }

As you can see, there is no meaningful arguments passed to
OCIEnvCreate()
so the problem would appear to be regardless of anything about
mapserver,
or GDAL.  I would suggest looking into OCI library versions and setup.
Do
other OCI client programs work on this system?   You might also try
looking
up the error code in the Oracle error database.

Best regards,
-- 
---------------------------------------+--------------------------------
------
I set the clouds in motion - turn up   | Frank Warmerdam,
warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGF,
http://osgeo.org