Oracle
PHP Manual

ora_bind

(PHP 4, PHP 5 <= 5.0.5)

ora_bind — Binds a PHP variable to an Oracle parameter

Описание

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.

Список параметров

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:

Constant Value
ORA_BIND_INOUT 0
ORA_BIND_IN 1
ORA_BIND_OUT 2

Возвращаемые значения

Возвращает TRUE в случае успешного завершения или FALSE в случае возникновения ошибки. Details about the error can be retrieved using the ora_error() and ora_errorcode() functions.

Список изменений

Версия Описание
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.

Примеры

Example#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"$len2);
  
ora_bind($curs"input"":in"51);
  
ora_bind($curs"output"":out"52);
  
$input 765;
  
ora_exec($curs);
  echo 
"Result: $result<br />Out: $output<br />In: $input";
?>

Примечания

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


Oracle
PHP Manual