<docbook><section><title>WhatDoesCountStoredProcedureParametersInSQLProceduresDo</title><para> </para><bridgehead class="http://www.w3.org/1999/xhtml:h2">What does Count Stored Procedure Parameters in SQLProcedures do?</bridgehead>
<para>This parameter is specific to the Oracle datasource.
 It affects the output from SQLProcedures when &quot;Custom Catalog Views&quot; is enabled (see also 9.12.12).</para><para>When &quot;Custom Catalog Views&quot; in on, &quot;Count Stored Procedure Parameters&quot; is enabled and an internal view, OPENLINK$SQL_PROCEDURES is used.
 When &quot;Custom Catalog Views&quot; is disabled, the internal view, OPENLINK$SQL_ PROCS_ NOCOUNT is used instead.
 Consequently, the NUM_ INPUT_ PARAMETERS, NUM_ OUTPUT_ PARAMETERS and NUM_ RESULT_ SETS columns of the SQLProcedures result set all contain ?1</para><para>The result set returned by SQL_PROCEDURES includes the number of input and output parameters for each procedure.
 The number of result sets is always ?1, as is the case when &quot;Custom Catalog Views&quot; is off.
 SQL_ PROCS_ NOCOUNT returns ?1 for the NUM_ INPUT_ PARAMETERS, NUM_ OUTPUT_ PARAMETERS and NUM_ RESULT_ SETS columns.
</para></section></docbook>