OracleDataReader Public Methods
OracleDataReader public methods are listed in Table 6-86.
Table 86 OracleDataReader Public Methods
| Public Method | Description |
|---|---|
| Close | Closes the OracleDataReader |
CreateObjRef |
Inherited from System.MarshalByRefObject |
| Dispose | Releases any resources or memory allocated by the object |
Equals |
Inherited from System.Object (Overloaded) |
| GetBoolean | Returns the bool value of the specified numeric column |
| GetByte | Returns the byte value of the specified column |
| GetByteArray(int) | Returns the byte array value of the specified numeric column Not Available in ODP.NET, Unmanaged Driver |
| GetByteArray(string) | Returns the byte array value of the specified numeric column Not Available in ODP.NET, Unmanaged Driver |
| GetBytes | Populates the provided byte array with up to the maximum number of bytes, from the specified offset (in bytes) of the column |
| GetChar | Not Supported |
| GetChars | Populates the provided character array with up to the maximum number of characters, from the specified offset (in characters) of the column |
| GetData | Not Supported |
| GetDataTypeName | Returns the ODP.NET type name of the specified column |
| GetDateTime | Returns the DateTime value of the specified column |
| GetDateTimeOffset | Returns the DateTimeOffset value of the specified column |
| GetDecimal | Returns the decimal value of the specified NUMBER column |
| GetDouble | Returns the double value of the specified NUMBER column or BINARY_DOUBLE column |
| GetDoubleArray(int) | Returns the double[] value of the specified VECTOR column |
| GetDoubleArray(string) | Returns the double[] value of the specified VECTOR column |
| GetEnumerator | Returns an IEnumerator that can be used to iterate through the collection |
| GetFieldType | Returns the Type of the specified column |
| GetFieldValueAsync | Returns a Task-based asynchronous version of OracleDataReader.GetFieldValue(), which returns the column value as a specified type (Overloaded) |
| GetFloat | Returns the float value of the specified NUMBER column or BINARY_FLOAT column |
| GetFloatArray(int) | Returns the float[] value of the specified VECTOR column |
| GetFloatArray(string) | Returns the float[] value of the specified VECTOR column |
| GetGuid | Returns the Guid value of the specified binary data column |
GetHashCode |
Inherited from System.Object |
| GetInt16 | Returns the Int16 value of the specified NUMBER column |
| GetInt16Array(int) | Returns the short[] value of the specified VECTOR column |
| GetInt16Array(string) | Returns the short[] value of the specified VECTOR column |
| GetInt32 | Returns the Int32 value of the specified NUMBER column |
| GetInt64 | Returns the Int64 value of the specified NUMBER column |
GetLifetimeService |
Inherited by System.MarshalByRefObject |
| GetName | Returns the name of the specified column |
| GetNonZeroDoubleArray | Returns the non-zero-dimension values Not Available in ODP.NET, Unmanaged Driver |
| GetNonZeroFloatArray | Returns the non-zero-dimension values Not Available in ODP.NET, Unmanaged Driver |
| GetNonZeroIndexArray | Returns the non-zero-dimension indices Not Available in ODP.NET, Unmanaged Driver |
| GetNonZeroInt16Array | Returns the non-zero-dimension values Not Available in ODP.NET, Unmanaged Driver |
| GetOracleBFile | Returns an OracleBFile object of the specified BFILE column |
| GetOracleBinary | Returns an OracleBinary structure of the specified column |
| GetOracleBlob | Returns an OracleBlob object of the specified BLOB column |
| GetOracleBlobForUpdate | Returns an updatable Not Available in ODP.NET, Managed Driver and ODP.NET Core |
| GetOracleBoolean(int) | Returns the OracleBoolean value of the column |
| GetOracleClob | Returns an OracleClob object of the specified CLOB column |
| GetOracleClobForUpdate | Returns an updatable Not Available in ODP.NET, Managed Driver and ODP.NET Core |
| GetOracleDataReader | Returns the Not Available in ODP.NET, Unmanaged Driver |
| GetOracleDate | Returns an OracleDate structure of the specified DATE column |
| GetOracleDecimal | Returns an OracleDecimal structure of the specified NUMBER column |
| GetOracleIntervalDS | Returns an OracleIntervalDS structure of the specified INTERVAL DAY TO SECOND column |
| GetOracleIntervalYM | Returns an OracleIntervalYM structure of the specified INTERVAL YEAR TO MONTH column |
| GetOracleRef | Returns an OracleRef object of the specified REF column |
| GetOracleRefCursor | Returns the Not Available in ODP.NET, Unmanaged Driver |
| GetOracleString | Returns an OracleString structure of the specified column |
| GetOracleTimeStamp | Returns an OracleTimeStamp structure of the Oracle TimeStamp column |
| GetOracleTimeStampLTZ | Returns an OracleTimeStampLTZ structure of the specified Oracle TimeStamp WITH LOCAL TIME ZONE column |
| GetOracleTimeStampTZ | Returns an OracleTimeStampTZ structure of the specified Oracle TimeStamp WITH TIME ZONE column |
| GetOracleXmlType | Returns an OracleXmlType object of the specified XMLType column |
| GetOracleValue | Returns the specified column value as a ODP.NET type |
| GetOracleValues | Gets all the column values as ODP.NET types |
| GetOracleVector | Returns Not Available in ODP.NET, Unmanaged Driver |
| GetOrdinal | Returns the 0-based ordinal (or index) of the specified column name |
| GetProviderSpecificFieldType | Returns the provider-specific type of the specified column |
| GetProviderSpecificValue | Returns an object that represents the underlying provider-specific value of the specified ordinal |
| GetProviderSpecificValues | Returns an array of objects that represent the underlying provider-specific values |
| GetSchemaTable | Returns a DataTable that describes the column metadata of the OracleDataReader |
| GetString | Returns the string value of the specified column. (Overloaded) |
| GetTimeSpan | Returns the TimeSpan value of the specified INTERVAL DAY TO SECOND column |
GetType |
Inherited from System.Object class |
| GetValue | Returns the column value as a .NET type |
| GetValues | Gets all the column values as .NET types |
| GetVectorDimensions | Returns the number of dimensions of the specified VECTOR column.(Overloaded) Not Available in ODP.NET, Unmanaged Driver |
| GetVectorNumericFormat(int) | Returns the OracleDbType value of the VECTOR column numeric format |
| GetVectorNumericFormat(string) | Returns the OracleDbType value of the VECTOR column numeric format |
| GetXmlReader | Returns the value of an XMLType column as an instance of an .NET XmlTextReader |
| IsDBNull | Indicates whether or not the column value is null |
| IsDBNullAsync | Returns a Task-based asynchronous version of OracleDataReader.IsDBNull() (Overloaded) |
| NextResult | Advances the data reader to the next result set when reading the results |
| NextResultAsync | Returns a Task-based asynchronous version of OracleDataReader.NextResult() (Overloaded) |
| Read | Reads the next row in the result set |
| ReadAsync | Returns a Task-based asynchronous version of OracleDataReader.Read() (Overloaded) |
ToString |
Inherited from System.Object |