OracleParameter Constructor (String, OracleType, Int32, ParameterDirection, Boolean, Byte, Byte, String, DataRowVersion, Object)

 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

Initializes a new instance of the OracleParameter class that uses the parameter name, data type, length, source column name, parameter direction, numeric precision, and other properties.

Namespace:   System.Data.OracleClient
Assembly:  System.Data.OracleClient (in System.Data.OracleClient.dll)

public OracleParameter(
	string name,
	OracleType oracleType,
	int size,
	ParameterDirection direction,
	bool isNullable,
	byte precision,
	byte scale,
	string srcColumn,
	DataRowVersion srcVersion,
	object value
)

Parameters

name
Type: System.String

The name of the parameter.

oracleType
Type: System.Data.OracleClient.OracleType

One of the OracleType values.

size
Type: System.Int32

The length of the parameter.

direction
Type: System.Data.ParameterDirection

One of the ParameterDirection values.

isNullable
Type: System.Boolean

true if the value of the field can be null, otherwise, false.

precision
Type: System.Byte

The total number of digits to the left and right of the decimal point to which Value is resolved.

scale
Type: System.Byte

The total number of decimal places to which Value is resolved.

srcColumn
Type: System.String

The name of the source column.

srcVersion
Type: System.Data.DataRowVersion

One of the DataRowVersion values.

value
Type: System.Object

An Object that is the value of the OracleParameter.

Exception Condition
ArgumentException

The value supplied in the oracleType parameter is an invalid back-end data type.

The following example creates an OracleParameter and displays the ParameterName.

public void CreateOracleParameter() 
 {
    OracleParameter parameter = new OracleParameter(
        "DName",OracleType.VarChar,
        11,ParameterDirection.Output,true,0,0,"DName",
        DataRowVersion.Current,"ENGINEERING");
    Console.WriteLine(parameter.ToString());
 }

.NET Framework
Available since 1.1
Return to top
Show: