GetString

This method returns the string value of the specified column.

Declaration

// C#
public override string GetString(int index);

Parameters

  • index

    The zero-based column index.

Return Value

The string value of the column.

Implements

IDataRecord

Exceptions

InvalidOperationException - The connection is closed, the reader is closed, Read() has not been called, or all rows have been read.

IndexOutOfRangeException - The column index is invalid.

InvalidCastException - The accessor method is invalid for this column type or the column value is NULL.

Remarks

GetString() can be called on all character-based column data types. Starting with managed ODP.NET and ODP.NET Core version 19.10, but not available in unmanaged ODP.NET, GetString() can be called on all non-binary data types, returning a string representation of the following additional types with the NLS format session setting honored:

  • NUMBER

  • DATE

  • TIMESTAMP

  • TIMESTAMP LTZ

  • TIMESTAMP TZ

  • INTERVAL YEAR TO MONTH

  • INTERVAL DAY TO SECOND

  • BINARY_DOUBLE

  • BINARY_FLOAT

  • FLOAT

Call the IsDBNull method to check for null values before calling this method.

If the column is an Oracle REF column, the string returned is a hexadecimal string that represents the REF in the database.

For VECTOR columns, the string returned is a JSON string that represents the VECTOR in the database. A sparse vector type column will return a JSON string in sparse format.

For ODP.NET managed and core, a JSON formatted string is returned for the cursor result set from Oracle REF CURSOR columns.

See Also: