<CFSTOREDPROC> [<CFPROCPARAM>] [<CFPROCRESULT>] ... </CFSTOREDPROC>
Executes a stored procedure on a data source.
The name of the stored procedure on the database server that you want to call. Required.
The data source that contains the stored procedure. Required.
The type of database driver to use. Optional. Possible choices are:
Connect to the data source using an ODBC driver.
Connect using an OLEDB driver.
Connect using the Oracle 7.3 native driver. This requires the 220.127.116.11.0 or later client libraries be installed on the ColdFusion server.
Connect using the Oracle 8 native driver. This requires the 8.0 or later client libraries be installed on the ColdFusion server.
Connect using the Sybase 11 native driver. This requires the 11.1.1 or later client libraries be installed on the ColdFusion server.
Connect using the DB2 5.2 native driver.
Connect using the Informix 7.3 native driver. This requires the Informix SDK 2.5 or later or Informix-Connect 2.5 (or later) for Windows.
Specifies the query should use an already existing query as the data
source. If this option is used, you don’t need to specify a
DATASOURCE. New as of ColdFusion 5.0.
Allows ColdFusion to make an ODBC connection to a data source without having to have the data source registered in the ColdFusion ...