This HTML5 document contains 4 embedded RDF statements represented using HTML+Microdata notation.

The embedded RDF content will be recognized by any processor of HTML5 Microdata.

Namespace Prefixes

Prefix	IRI
wdrs	http://www.w3.org/2007/05/powder-s#
schema	http://schema.org/
n6	https://www.openlinksw.com/about/id/entity/https/www.openlinksw.com/DAV/data/turtle/general/
n4	https://www.openlinksw.com/about/id/entity/https/www.openlinksw.com/data/turtle/general/
rdf	http://www.w3.org/1999/02/22-rdf-syntax-ns#
n2	http://data.openlinksw.com/oplweb/faq/UDA/WhatDoesCountStoredProcedureParametersInSQLProceduresDoAnswer#
xsdh	http://www.w3.org/2001/XMLSchema#

Statements

Subject Item

n2:this

wdrs:describedby

n4:uda-faq.ttl n6:uda-faq.ttl

rdf:type

schema:Answer

schema:answerExplanation

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.