inParameter

Syntax

void inParameter(
  resource &$statementt,
  string &$var,
  string $name,
  int $maxLen=4000,
  mixed $type=false
  )

Description

The function inParameter() sets an input parameter for a stored procedure. The $statement variable must be a handle to a stored procedure accessed via the prepareSp() method.

Parameters

$statement

A handle to a stored procedure.

$var

The value of the input parameter.

$name

The name of the input parameter.

$maxLen

(optionally) The length of the value. If not assigned then the length is automatically assigned.

$type

(optionally the field type. If not assigned then the type is automatically determined.

Usage

/*
* Connection to Oracle database
*/
 
$cat  = 'Dairy Products';
$yr   = '1998';
 
$stmt = $db->prepareSp('SalesByCategory');
$db->inParameter($stmt,$cat,'CategoryName');
$db->inParameter($stmt,$yr,'OrdYear');
 
$rs = $db->execute($stmt);