Macromedia coldfusion 4.5-cfml language reference User Manual

Chapter 1:  ColdFusion Tags

207

CFSTOREDPROC

The CFSTOREDPROC tag is the main tag used for executing stored procedures via an 
ODBC or native connection to a server database. It specifies database connection 
information and identifies the stored procedure.

<CFSTOREDPROC PROCEDURE="procedure name"

DATASOURCE="ds_name"
USERNAME="username"
PASSWORD="password"
DBSERVER="dbms"
DBNAME="database name"
BLOCKFACTOR="blocksize"
PROVIDER="COMProvider" 
PROVIDERDSN="datasource" 
DEBUG="Yes/No"
RETURNCODE="Yes/No">

Required. Specifies the name of the stored procedure on the database server.

Required. The name of an ODBC or native data source that points to the database 
containing the stored procedure.

Optional. If specified, USERNAME overrides the username value specified in the 
data source setup.

Optional. If specified, PASSWORD overrides the password value specified in the 
data source setup.

Optional. For native database drivers, specifies the name of the database server 
machine. If specified, DBSERVER overrides the server specified in the data source.

Optional. The database name (Sybase System 11 driver only). If specified, 
DBNAME overrides the default database specified in the data source.

Optional. Specifies the maximum number of rows to fetch at a time from the 
server. The range is 1 (default) to 100. The ODBC driver may dynamically reduce 
the block factor at runtime.

Optional. COM provider (OLE-DB only).