= doc.FAQ.WhatDoesCountStoredProcedureParametersInSQLProceduresDo

%TOC%

   
This applies to the Oracle data-source. 

"Count Stored Procedure Parameters" affects the output from SQLProcedures when "Custom Catalog Views" is enabled. 

When "Custom Catalog Views" is off, the NUM **INPUT_PARAMETERS, NUM_OUTPUT_PARAMETERS and NUM_RESULT_SETS columns of the SQLProcedures result set all contain -1. ** 

When "Custom Catalog Views" in on, "Count Stored Procedure Parameters" is enabled and an internal view, OPENLINK$SQL_PROCEDURES is used; when this is disabled, the internal view, OPENLINK$SQL **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 "Custom Catalog Views" is off, SQL_PROCS_NOCOUNT returns -1 for the NUM_INPUT_PARAMETERS, NUM_OUTPUT_PARAMETERS and NUM_RESULT_SETS columns. ** 


----