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.

In This Topic
    ExecuteProcedure(String,OracleParameterCollection,Boolean) Method
    In This Topic
    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
    public object ExecuteProcedure( 
       string name,
       OracleParameterCollection parameters,
       bool parameterCheck
    )

    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