dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleConnectionStringBuilder Class / DescribeStoredProcedure Property

In This Topic
    DescribeStoredProcedure Property (OracleConnectionStringBuilder)
    In This Topic
    Enables or disables additional check queries, performed when executing an OracleCommand with CommandType equal to CommandType.StoredProcedure.
    Syntax
    'Declaration
     
    Public Property DescribeStoredProcedure As Boolean
    public bool DescribeStoredProcedure {get; set;}

    Property Value

    true if additional queries for stored routine metadata must be performed; otherwise, false. Default value is true.
    Remarks

    When this parameter is set to true (the default behavior), the following additional checks are performed for OracleCommand with CommandType equal to CommandType.StoredProcedure:

    • First, a query is sent to determine whether the command is a call to a pipelined table-valued function.
    • If this is not the call to a pipelined table-valued function, the second query describes procedure parameters.

    To disable these checks for a single OracleCommand instance set the OracleCommand.IsTableValuedFunction property (depending on whether this command is a table-valued function call), and set OracleCommand.ImplicitRefCursors to 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