User Guide

404 Chapter 2: ColdFusion Tags
cfstoredproc
Description
Executes a stored procedure in a server database. It specifies database connection information and
identifies the stored procedure.
Category
Database manipulation tags
Syntax
<cfstoredproc
procedure = "procedure name"
dataSource = "ds_name"
username = "username"
password = "password"
blockFactor = "blocksize"
debug = "yes" or "no"
returnCode = "yes" or "no">
result = "result_name"
See also
cfinsert
, cfqueryparam, cfprocparam, cfprocresult, cftransaction, cfquery, cfupdate;
“Optimizing database use” in Chapter 13, “Designing and Optimizing a
ColdFusion Application,” in ColdFusion MX Developer’s Guide
History
ColdFusion MX 7: Added the result attribute.
ColdFusion MX: Deprecated the
connectString, dbName, dbServer, dbtype, provider, and
providerDSN attributes. They do not work, and might cause an error, in releases later than
ColdFusion 5. (ColdFusion MX uses Type 4 JDBC drivers.)
Attributes
Attribute Req/Opt Default Description
procedure Required Name of stored procedure on database server.
dataSource Required Name of data source that points to database that
contains stored procedure.
username Optional Overrides username in data source setup.
password Optional Overrides password in data source setup.
blockFactor Optional 1 Maximum number of rows to get at a time from server.
Range is 1 to 100.
debug Optional No • Yes: lists debug information on each statement.
• No