<docbook><section><title>UdadocFAQWhatDoesCountStoredProcedureParametersInSQLProceduresDo</title><para> </para><title> doc.FAQ.WhatDoesCountStoredProcedureParametersInSQLProceduresDo</title> doc.FAQ.WhatDoesCountStoredProcedureParametersInSQLProceduresDo
<para> This applies to the Oracle data-source.</para><para>&quot;Count Stored Procedure Parameters&quot; affects the output from SQLProcedures when &quot;Custom Catalog Views&quot; is enabled.</para><para>When &quot;Custom Catalog Views&quot; is off, the NUM <emphasis>INPUT_PARAMETERS, NUM_OUTPUT_PARAMETERS and NUM_RESULT_SETS columns of the SQLProcedures result set all contain -1.
 </emphasis></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 this is disabled, the internal view, OPENLINK$SQL <emphasis>PROCS_NOCOUNT is used instead.
 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 like 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.
 </emphasis></para><para> </para></section></docbook>