ADOdb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== inParameter ======
~~NOTOC~~
<WRAP right box>
== Syntax ==
  void inParameter(
    resource &$statementt,
    string &$var,
    string $name,
    int $maxLen=4000,
    mixed $type=false
    )
</WRAP>
===== 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 [[v5:reference:connection:preparesp|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 =====
<code php>
/*
* 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);
</code>