ora_do

(PHP 3, PHP 4 , PHP 5)

ora_do -- Parse, Exec, Fetch

Description

resource ora_do ( resource conn, string query)

ora_do() is quick combination of ora_parse(), ora_exec() and ora_fetch(). It will parse and execute a statement, then fetch the first result row.

This function returns a cursor index or FALSE on failure. Details about the error can be retrieved using the ora_error() and ora_errorcode() functions.

See also ora_parse(),ora_exec(), and ora_fetch().

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