User Guide

cfprocparam 275
Usage
Use this tag to identify stored procedure parameters and their data types. Code one cfprocparam
tag for each parameter. The parameters that you code vary based on parameter type and DBMS.
ColdFusion MX supports positional parameters only and you must code
cfprocparam tags in the
same order as the associated parameters in the stored procedure definition.
Output variables are stored in the ColdFusion variable specified by the
variable attribute.
You cannot use the cfprocparam tag for Oracle 8 reference cursors. Instead, use the
cfprocresult tag.
CFSQLType Required SQL type to which the parameter (any type) is bound.
ColdFusion supports the following values, where the last
element of the name corresponds to the SQL data type.
Different database systems might support different subsets
of this list. See your DBMS documentation for information
on supported parameter types.
• CF_SQL_BIGINT
• CF_SQL_BIT
• CF_SQL_BLOB
• CF_SQL_CHAR
• CF_SQL_CLOB
• CF_SQL_DATE
• CF_SQL_DECIMAL
• CF_SQL_DOUBLE
• CF_SQL_FLOAT
• CF_SQL_IDSTAMP
• CF_SQL_INTEGER
• CF_SQL_LONGVARCHAR
• CF_SQL_MONEY
• CF_SQL_MONEY4
• CF_SQL_NUMERIC
• CF_SQL_REAL
• CF_SQL_REFCURSOR
• CF_SQL_SMALLINT
• CF_SQL_TIME
• CF_SQL_TIMESTAMP
• CF_SQL_TINYINT
• CF_SQL_VARCHAR
maxLength Optional 0 Maximum length of a string or character IN or INOUT value
attribute. A maxLength of 0 allows any length. The
maxLength attribute is not required when specifying
type=out.
scale Optional 0 Number of decimal places in numeric parameter. A scale of
0 allows any number of decimal places.
null Optional No Whether the parameter is passed in as a null value. Not used
with OUT type parameters.
• Yes: tag ignores the value attribute
• No
Attribute Req/Opt Default Description