MACROMEDIA COLDFUSION MX 61-CFML, Reference

Page: 275 / 806

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