User Guide

274 Chapter 2: ColdFusion Tags
cfprocparam
Description
Defines stored procedure parameters. This tag is nested within a cfstoredproc tag.
Category
Database manipulation tags
Syntax
<cfprocparam
type = "in" or "out" or "inout"
variable = "variable name"
value = "parameter value"
CFSQLType = "parameter datatype"
maxLength = "length"
scale = "decimal places"
null = "Yes" or "No">
See also
cfinsert, cfprocresult, cfquery, cfqueryparam, cfstoredproc, cftransaction,
cfupdate
History
ColdFusion MX:
• The maxrows attribute is obsolete.
• Changed the dbvarname attribute behavior: it is now ignored for all drivers. ColdFusion MX
uses JDBC 2.2 and does not support named parameters.
• Changed the maxLength attribute behavior: it now applies to IN and INOUT parameter
values.
Attributes
Attribute Req/Opt Default Description
type Optional in • in: The parameter is used to send data to the database
system only. Passes the parameter by value.
• out: The parameter is used to receive data from the
database system only. Passes the parameter as a bound
variable.
• inout: The parameter is used to send and receive data.
Passes the parameter as a bound variable.
variable Required if
type = "OUT"
or
"INOUT"
ColdFusion variable name; references the value that the
output parameter has after the stored procedure is called.
value Required if
type = "IN"
or
"INOUT"
Value that ColdFusion passes to the stored procedure.