User Guide

328 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">
See also
cfinsert, cfqueryparam, cfprocparam, cfprocresult, cftransaction, cfquery,
cfupdate
History
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
Usage
Use this tag to call a database stored procedure. Within this tag, you code cfprocresult and
cfprocparam tags as follows:
• cfprocresult If the stored procedure returns one or more result sets, code one
cfprocresult tag per result set.
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
returnCode Optional No • Yes: Tag populates
cfstoredproc.statusCode with
status code returned by stored procedure.
• No