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

DescribeStoredProcedure Property (OracleConnectionStringBuilder)
Enables or disables additional check queries, performed when executing an OracleCommand with CommandType equal to CommandType.StoredProcedure.
Syntax
'Declaration
 
Public Property DescribeStoredProcedure As Boolean
 

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