(PHP 3 <= 3.0.18, PHP 4 >= 4.0.0)
Ora_Bind -- bind a PHP variable to an Oracle parameter
Description
int ora_bind (int cursor, string PHP variable name, string SQL
parameter name, int length [, int type])
Returns TRUE if the bind succeeds, otherwise FALSE.
Details about the error can be retrieved using the
ora_error() and ora_errorcode()
functions.
This function binds the named PHP variable with a SQL parameter. The SQL parameter must be
in the form ":name". With the optional type parameter, you can define whether the SQL parameter is
an in/out (0, default), in (1) or out (2) parameter. As of PHP 3.0.1, you can use the constants
ORA_BIND_INOUT, ORA_BIND_IN and ORA_BIND_OUT instead of the numbers.
ora_bind must be called after ora_parse() and
before ora_exec(). Input values can be given by
assignment to the bound PHP variables, after calling
ora_exec() the bound PHP variables contain the output values if available.
<?php
ora_parse($curs, "declare tmp INTEGER; begin tmp := :in; :out := tmp; :x := 7.77; end;");
ora_bind($curs, "result", ":x", $len, 2);
ora_bind($curs, "input", ":in", 5, 1);
ora_bind($curs, "output", ":out", 5, 2);
$input = 765;
ora_exec($curs);
echo "Result: $result<BR>Out: $output<BR>In: $input";
?>
|
|
