Function msOracleSpatialLayerNextShape

maporaclespatial.c:2254–2355

fetch next shape from previous SELECT stmt (see *WhichShape()) */

/* fetch next shape from previous SELECT stmt (see *WhichShape()) */
int msOracleSpatialLayerNextShape( layerObj *layer, shapeObj *shape )
{
    SDOGeometryObj *obj;
    SDOGeometryInd *ind;
    int success, /*lIntSuccessFree,*/ i;

    /* get layerinfo */
    msOracleSpatialLayerInfo *layerinfo = (msOracleSpatialLayerInfo *)layer->layerinfo;
    msOracleSpatialDataHandler *dthand = NULL;
    msOracleSpatialHandler *hand = NULL;
    msOracleSpatialStatement *sthand = NULL;


    if (layerinfo == NULL) 
    {
        msSetError( MS_ORACLESPATIALERR, "msOracleSpatialLayerWhichShapes called on unopened layer", "msOracleSpatialLayerNextShape()" );
        return MS_FAILURE;
    }
    else
    {
        dthand = (msOracleSpatialDataHandler *)layerinfo->oradatahandlers;
        hand = (msOracleSpatialHandler *)layerinfo->orahandlers;
        sthand = (msOracleSpatialStatement *)layerinfo->orastmt2;
    }

    /* no rows fetched */
    if (sthand->rows_fetched == 0)
        return MS_DONE;

    if(layer->debug >=5 )
        msDebug("msOracleSpatialLayerNextShape on layer %p, row_num: %d\n", layer, sthand->row_num);
    
    do{
        /* is buffer empty? */
        if (sthand->row >= sthand->rows_fetched)
        {
            /* fetch more */
            success = TRY( hand, OCIStmtFetch2( sthand->stmthp, hand->errhp, (ub4)ARRAY_SIZE, (ub2)OCI_FETCH_NEXT, (sb4)0, (ub4)OCI_DEFAULT ) ) 
                   && TRY( hand, OCIAttrGet( (dvoid *)sthand->stmthp, (ub4)OCI_HTYPE_STMT, (dvoid *)&sthand->rows_fetched, (ub4 *)0, (ub4)OCI_ATTR_ROWS_FETCHED, hand->errhp ) )
                   && TRY( hand, OCIAttrGet( (dvoid *)sthand->stmthp, (ub4)OCI_HTYPE_STMT, (dvoid *)&sthand->rows_count, (ub4 *)0, (ub4)OCI_ATTR_ROW_COUNT, hand->errhp ) );

            if(layer->debug >= 4 )
                msDebug("msOracleSpatialLayerNextShape on layer %p, Fetched %d more rows (%d total)\n", layer, sthand->rows_fetched, sthand->rows_count);
            
            
            if (!success || sthand->rows_fetched == 0)
                return MS_DONE;

            if (sthand->row_num >= sthand->rows_count)
                return MS_DONE;

            sthand->row = 0; /* reset buffer row index */
        }

        /* set obj & ind for current row */
        obj = sthand->obj[ sthand->row ];
        ind = sthand->ind[ sthand->row ];