PassParametersByName Property (OracleCommand)

In This Topic

Gets or sets a value indicating whether stored procedure parameters are passed anonimously or with the names specified.

Syntax

Visual Basic
C#

'Declaration
 
Public Property PassParametersByName As Boolean

public bool PassParametersByName {get; set;}

Property Value

true if parameter names are specified in the procedure invocation; otherwise, false.

Remarks

With this property set to false, a procedure will be called like "Proc(:param1, :param2)" or "Proc(:param2, :param1)" subject to parameters order. If true, the statement will be like "Proc(param2 => :param2, param1 => :param1)", thus result will be the same regardless of parameters order.

This property can be used with any value of the ParameterCheck property. Ignored if CommandType is other than CommandType.StoredProcedure.

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

OracleCommand Class
OracleCommand Members

Send Feedback