Programming ColdFusion

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 is Out or InOut.

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 is In or InOut.

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, and CF_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. If Yes, ColdFusion ignores ...