name = oci_field_name($this->_queryID, $fieldOffset); $fld->type = oci_field_type($this->_queryID, $fieldOffset); $fld->max_length = oci_field_size($this->_queryID, $fieldOffset); //if ($fld->name == 'VAL6_NUM_12_4') $fld->type = 'NUMBER'; switch($fld->type) { case 'string': $fld->type = 'VARCHAR'; break; case 'real': $fld->type = 'NUMBER'; break; } } else { $fieldOffset += 1; $fld->name = oci_field_name($this->_queryID, $fieldOffset); $fld->type = oci_field_type($this->_queryID, $fieldOffset); $fld->max_length = oci_field_size($this->_queryID, $fieldOffset); } switch($fld->type) { case 'NUMBER': $p = oci_field_precision($this->_queryID, $fieldOffset); $sc = oci_field_scale($this->_queryID, $fieldOffset); if ($p != 0 && $sc == 0) $fld->type = 'INT'; $fld->scale = $p; break; case 'CLOB': case 'NCLOB': case 'BLOB': $fld->max_length = -1; break; } return $fld; } }