ora_bind

Binds a PHP variable to an Oracle parameter (PHP 4, PHP 5 <= 5.0.5)
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.

Parameters

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

Return Values

Returns TRUE on success or FALSE on failure. Details about the error can be retrieved using the ora_error() and ora_errorcode() functions.

ChangeLog

Version	Description
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.

Examples

Example 1679. ora_bind() example

copy to clipboard

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

Notes

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

oci_bind_by_name()

oci_bind_array_by_name()

Code Examples / Notes » ora_bind

It was hard a little bit to understand the example above. Since it did not work properly :( I managed to get a similar one running, the whole example is as following: <?php $connection = ora_logon("user@DBname", "password"); $cursor = ora_open($connection); ora_commitoff($connection); $cursor=ora_parse($cursor, "begin user.user_create (:name,:surname,:street,:country,:postal,:city,:tel,:mail,:number); end;"); $name = 'a'; $surname = 'a'; $street = 'a'; $country = 'a'; $postal = 'a'; $city = 'a'; $tel = 'a'; $mail = 'a'; ora_bind($cursor, "name", ":name", 32, 1); ora_bind($cursor, "surname", ":surname", 32, 1); ora_bind($cursor, "street", ":street", 32, 1); ora_bind($cursor, "country", ":country", 32, 1); ora_bind($cursor, "postal", ":postal", 32, 1); ora_bind($cursor, "city", ":city", 32, 1); ora_bind($cursor, "tel", ":tel", 32, 1); ora_bind($cursor, "mail", ":mail", 32, 1); ora_bind($cursor, "number", ":number", 32, 2); // The following step is to charge the output variable with an intial value (Actually still doesn't know why? but it works like this ;-)) ) $okdnr = "a"; ora_exec($cursor); print "okdnr is $okdnr"; ?> The called stored procedure is as following: CREATE OR REPLACE procedure customer_create ( iname in varchar2, insurname in varchar2, instreet in varchar2, incountry varchar2, inpostal in varchar2, incity in varchar2, intel in varchar2, inemail in varchar2, okdnr out varchar2) is begin ..... ..... SOME CODE .... ..... okdnr:='something_to_output'; commit; end customer_create; / The most important part of all this is the ora_bind function. Becarefull while writing the syntax regarding the definition wether the variable is an INPUT (1) variable or an OUTPUT variable (2). Hope this help someone!!

Ahmed's solution is based on the sample given to him in http://forums.oracle.com/forums/thread.jsp?forum=178&thread=206340 Here's a similar example answering the question "How do I get the return value from a PL/SQL function?" <?php /* Sample using "oracle" driver to get the value of a PL/SQL function. Before running this script create this function using SQL*Plus: create or replace function myfunc(myparam IN varchar2) return varchar2 as begin return myparam; end; Tested with PHP 4.3.3 against Oracle 9.2 */ $my_db_conn = ora_logon("scott@mydb", "tiger"); $my_cursor = ora_open($my_db_conn); $sql = "begin :mybindvar := myfunc('abcde'); end;"; ora_parse($my_cursor, $sql, 0); $r = ora_bind($my_cursor, "mybindvar", ":mybindvar", 5, 1); // Set the OUT bind variable to anything (?), else get: // Warning: Can't find variable for parameter // Notice: Undefined variable: mybindvar $mybindvar = NULL; ora_exec($my_cursor); print 'Return value is: '. $mybindvar; ?>