Name
CFPROCPARAM
Synopsis
<CFSTOREDPROC> [<CFPROCPARAM>] [<CFPROCRESULT>] ... </CFSTOREDPROC>
Specifies parameter information to send to a stored procedure.
CFPROCPARAM
tags are nested within a
CFSTOREDPROC
tag.
Attributes
-
TYPE="In|Out|InOut"
Whether the variable being passed is an input, output, or input/output variable. Optional. Default is
In
.-
VARIABLE="
variable_name
"
The name of the ColdFusion variable that references the value returned by the output parameter after the stored procedure is called. Required when
TYPE
isOut
orInOut
.-
DBVARNAME="
database_variable_name
"
The name of the parameter within the stored procedure. Required if named notation is used.
-
VALUE="
parameter_value
"
The value to pass to the stored procedure. Required when
TYPE
isIn
orInOut
.-
CFSQLTYPE="
parameter_data_type
"
The SQL type of the parameter being passed to the stored procedure. Required. The default is
CF_SQL_CHAR
. Possible values are:CF_SQL_BIGINT
,CF_SQL_BIT
,CF_SQL_CHAR
,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
(Oracle only),CF_SQL_SMALLINT
,CF_SQL_TIME
,CF_SQL_TIMESTAMP
,CF_SQL_TINYINT
, andCF_SQL_VARCHAR
.-
MAXLENGTH="
length
"
The maximum length of the parameter. Optional.
-
SCALE="
decimal_places
"
The number of decimal places of the parameter. Optional.
-
NULL="Yes|No"
Whether or not the value passed is a
NULL
. IfYes
, ColdFusion ignores ...
Get Programming ColdFusion now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.