Sergio Hernandez wrote:

Hi, we are working in php with oracle and we have a stupid problem.

We are trying to obtain the return value of a variable. But after execute the function it give to us an empty value, its return 0 columns and 1 row. We have prove this function in oracle and it give a good result.

The code is :

$sql="declare identificador number; begin identificador:=InsertarObtenerIdArticulo('PruebaFuncion', 1, 500); end;";

$identificador=ora_do($ora_conn, $sql);

I've never used the old Oracle 7 interface for anything serious, and have barely used PHP's driver for it, but try something like this:


  Sample using "oracle" driver to get the value of a function.

Before running this script create this function using SQL*Plus:

    create or replace function myfunc(myparam IN number) return number as
          return myparam;

  Tested with PHP 4.3.3 against Oracle 9.2

$my_db_conn = ora_logon("[EMAIL PROTECTED]", "tiger");

$my_cursor = ora_open($my_db_conn);

$sql = "begin :mybindvar := myfunc(500); end;";

ora_parse($my_cursor, $sql, 0);

$r = ora_bind($my_cursor, "mybindvar", ":mybindvar", 4 /* 4? */, 2);

// Set the OUT bind variable to anything (?), otherwise you get:
//    Warning: Can't find variable for parameter
//    Notice: Undefined variable: mybindvar
$mybindvar = 0;


print 'Return value is: '. $mybindvar;


There's a comment on using OUT bind variable in the oracle driver in
Oracle's PHP forum at:

If the PHP and Oracle combination is new to you, the general
recommendation is to use the "oci8" driver where possible instead of
"oracle".  It has several advantages over the old "oracle" driver,
not least being that seems to have better support.  See


PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to