MACROMEDIA COLDFUSION 4.5-CFML LANGUAGE, Reference

Page: 231 / 608

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.
Syntax
<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">
PROCEDURE
Required. Specifies the name of the stored procedure on the database server.
DATASOURCE
Required. The name of an ODBC or native data source that points to the database
containing the stored procedure.
USERNAME
Optional. If specified, USERNAME overrides the username value specified in the
data source setup.
PASSWORD
Optional. If specified, PASSWORD overrides the password value specified in the
data source setup.
DBSERVER
Optional. For native database drivers, specifies the name of the database server
machine. If specified, DBSERVER overrides the server specified in the data source.
DBNAME
Optional. The database name (Sybase System 11 driver only). If specified,
DBNAME overrides the default database specified in the data source.
BLOCKFACTOR
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.
PROVIDER
Optional. COM provider (OLE-DB only).