dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OraclePackage Class / ExecuteProcedure Method / ExecuteProcedure(String,OracleParameterCollection,Boolean) Method
The name of the stored procedure or function.
Parameters to be passed to the procedure as arguments.
If true, collection of parameters is automatically adjusted to correspond to stored procedure's declaration.

ExecuteProcedure(String,OracleParameterCollection,Boolean) Method
Executes stored procedure or function.
Syntax
'Declaration
 
Public Overloads Function ExecuteProcedure( _
   ByVal name As String, _
   ByVal parameters As OracleParameterCollection, _
   ByVal parameterCheck As Boolean _
) As Object
 

Parameters

name
The name of the stored procedure or function.
parameters
Parameters to be passed to the procedure as arguments.
parameterCheck
If true, collection of parameters is automatically adjusted to correspond to stored procedure's declaration.

Return Value

Return value of the stored function.
Remarks

When collection of parameters does not correspond strictly to declaration of a stored procedure, behavior of ExecuteProcedure depends on parameterCheck value. When parameterCheck is true, missing parameters are added to the collection and wrong parameters are removed from it. For stored functions, routine result is placed in a parameter with Devart.Common.DbParameterBase.Direction set to ReturnValue and Devart.Common.DbParameterBase.ParameterName "Result". For more information on this mode please refer to article Using Parameters.

If a procedure with specified name cannot be found in the package an exception is thrown. This is also the case when you specify wrong parameters and parameterCheck is false.

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

See Also