OracleParameter Properties

OracleParameter properties are listed in Table 7-127.

Table 7-127 OracleParameter Properties

Property Description

ArrayBindSize

Specifies the input or output size of elements in Value property of a parameter before or after an Array Bind or PL/SQL Associative Array Bind execution

ArrayBindStatus

Specifies the input or output status of elements in Value property of a parameter before or after an Array Bind or PL/SQL Associative Array Bind execution

CollectionType

Specifies whether or not the OracleParameter represents a collection, and if so, specifies the collection type

DbType

Specifies the data type of the parameter using the Data.DbType enumeration type

Direction

Specifies whether the parameter is input-only, output-only, bi-directional, or a stored function return value parameter

IsNullable

Not supported

Offset

Specifies the offset to the Value property or offset to the elements in the Value property

OracleDbType

Specifies the Oracle data type

OracleDbTypeEx

Specifies the Oracle data type to bind the parameter as, but returns a .NET type as output

ParameterName

Specifies the name of the parameter

Precision

Specifies the maximum number of digits used to represent the Value property

Scale

Specifies the number of decimal places to which Value property is resolved

Size

Specifies the maximum size, in bytes or characters, of the data transmitted to or from the database. For PL/SQL Associative Array Bind, Size specifies the maximum number of elements in PL/SQL Associative Array

SourceColumn

Specifies the name of the DataTable Column of the DataSet

SourceColumnNullMapping

Specifies a value which indicates whether the source column is nullable

SourceVersion

Specifies the DataRowVersion value to use when loading the Value property of the parameter

Status

Indicates the status of the execution related to the data in the Value property

UdtTypeName

Specifies the Oracle user-defined type name if the parameter is a user-defined data type

Value

Specifies the value of the Parameter