Forum und email
ora_bind

ora_bind

(PHP 3, PHP 4, PHP 5 <= 5.1.0RC1)

ora_bind -- Binds a PHP variable to an Oracle parameter

Popis

bool ora_bind ( resource cursor, string phpvar, string sqlparam, int length [, int type] )

Binds the named PHP variable with a SQL parameter.

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.

Seznam parametrů

cursor

An Oracle cursor, opened with ora_open().

phpvar

The PHP variable to be bound.

sqlparam

The SQL parameter. Must be in the form :name.

length

type

Defines the type of the parameter. It defaults to ORA_BIND_INOUT. Possible values are listed below:

ConstantValue
ORA_BIND_INOUT0
ORA_BIND_IN1
ORA_BIND_OUT2

Návratové hodnoty

Vrací TRUE při úspěchu, FALSE při selhání. Details about the error can be retrieved using the ora_error() and ora_errorcode() functions.

ChangeLog (záznam změn)

VerzePopis
5.1.0

The oracle extension is deprecated in favor of oci8.

3.0.1 The constants for the type were added. In previous versions, you should use the numerical values.

Příklady

Příklad 1. ora_bind() example

<?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";
?>

Poznámky

When using oci8 as a replacement for the deprecated oracle extension, consider using:

oci_bind_by_name()
oci_bind_array_by_name()