GetValue(OracleConnection, object, string, out object)

This method returns either the elements of the specified collection attribute of the specified Oracle Object or the elements of the specified Oracle Collection.

Declaration

// C#
public static object GetValue(OracleConnection con, object Udt, string attrName,
  out object statusArray);

Parameters

con

An OracleConnection instance.
pUdt

An Oracle UDT object.
attrName

The case-sensitive name of the attribute to be retrieved. Null must specified for retrieving collection elements from a Custom Type that represents an Oracle Collection.
statusArray

The OracleUdtStatus array which returns the null status for the retrieved collection elements.

Return Value

An object representing the returned attribute or collection elements.

Exceptions

ArgumentException - The specified name is not a valid attribute name.

Remarks

The IOracleCustomType.ToCustomObject method invokes OracleUdt.GetValue method passing it the con and Udt parameters. The OracleUdt.GetValue method returns these types of object:

Oracle Object Type

For a Custom Type that represents an Oracle Object Type, the type returned for a specified attribute name is the type of the member in the custom class or struct that is mapped to the attribute using the OracleObjectMappingAttribute object.
Oracle Collection Type

For a Custom Type that represents an Oracle Collection Type, the type returned is the type of the member in the custom class or struct to which the OracleArrayMappingAttribute object is applied.

In the case of NULL attribute values, the appropriate null representation of the type is returned. For example, for attributes that are represented as Custom Types and Provider Specific Types, the static Null property of the type is returned. For attributes that are represented as Nullable types, for example, System.String and System.Array Types, null is returned, and for all other remaining built-in types such as Int32 and DateTime DBNull.Value is returned.

If the collection being returned is not NULL, the output statusArray parameter is populated with the null status for each of the collection elements.

If the type of the member is mapped to a .NET Decimal, and SuppressGetDecimalInvalidCastException is set to true on OracleConfiguration, OracleConnection, OracleDataAdapter, or OracleDataReader associated with the UDT, then it returns a rounded-off 28 or 29 precision Oracle NUMBER value that can be represented as a .NET Decimal.

See Also: