Ask a question?
  • Contact Us
  • Support Case System
  • Support Forum

What Does Count Stored Procedure Parameters In SQL Procedures Do?

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.