void inParameter( resource &$statementt, string &$var, string $name, int $maxLen=4000, mixed $type=false )
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.
A handle to a stored procedure.
The value of the input parameter.
The name of the input parameter.
(optionally) The length of the value. If not assigned then the length is automatically assigned.
(optionally the field type. If not assigned then the type is automatically determined.
/* * 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);