Function msOracleSpatialLayerOpen

maporaclespatial.c:1750–1853

opens a layer by connecting to db with username/password@database stored in layer->connection */

/* opens a layer by connecting to db with username/password@database stored in layer->connection */
int msOracleSpatialLayerOpen( layerObj *layer )
{
    char *username = NULL, *password = NULL, *dblink =  NULL;

    msOracleSpatialLayerInfo *layerinfo = NULL;
    msOracleSpatialDataHandler *dthand = NULL;
    msOracleSpatialStatement *sthand = NULL, *sthand2 = NULL;
    msOracleSpatialHandler *hand = NULL;
    
    if (layer->debug)
        msDebug("msOracleSpatialLayerOpen called with: %s (Layer pointer %p)\n",layer->data, layer);

    if (layer->layerinfo != NULL) /* Skip if layer is already open */
        return MS_SUCCESS;

    if (layer->data == NULL) 
    {
        msSetError( MS_ORACLESPATIALERR, 
                    "Error parsing OracleSpatial DATA variable. Must be:"
                    "'geometry_column FROM table_name [USING UNIQUE <column> SRID srid# FUNCTION]' or "
                    "'geometry_column FROM (SELECT stmt) [USING UNIQUE <column> SRID srid# FUNCTION]'."
                    "If want to set the FUNCTION statement you can use: FILTER, RELATE, GEOMRELATE or NONE.",
                    "msOracleSpatialLayerOpen()");

        return MS_FAILURE;
    }

    layerinfo = (msOracleSpatialLayerInfo *)malloc(sizeof(msOracleSpatialLayerInfo));
    dthand = (msOracleSpatialDataHandler *)malloc(sizeof(msOracleSpatialDataHandler));
    sthand = (msOracleSpatialStatement *)malloc(sizeof(msOracleSpatialStatement));
    sthand2 = (msOracleSpatialStatement *)malloc(sizeof(msOracleSpatialStatement));

    if ((dthand == NULL) || (layerinfo == NULL))
    {
        msSetError(MS_MEMERR, NULL, "msOracleSpatialLayerOpen()");
        return MS_FAILURE;
    }

    memset( dthand, 0, sizeof(msOracleSpatialDataHandler) );
    memset( sthand, 0, sizeof(msOracleSpatialStatement) );
    memset( sthand2, 0, sizeof(msOracleSpatialStatement) );
    memset( layerinfo, 0, sizeof(msOracleSpatialLayerInfo) );

    msSplitLogin( layer->connection, layer->map, &username, &password, &dblink );

    hand = (msOracleSpatialHandler *) msConnPoolRequest( layer );

    if( hand == NULL )
    {

        hand = msOCISetHandlers( username, password, dblink );

        if (hand == NULL)
        {
            msOCICloseDataHandlers( dthand );
            msOCIFinishStatement( sthand );
            msOCIFinishStatement( sthand2 );
            msOCIClearLayerInfo( layerinfo );