INGRES_FETCH_PROC_RETURN(3)						 1					       INGRES_FETCH_PROC_RETURN(3)

ingres_fetch_proc_return - Get the return value from a procedure call

SYNOPSIS

       int ingres_fetch_proc_return (resource  $result)

DESCRIPTION

	This function is used to retrieve the return value following the execution of an Ingres database procedure (stored procedure).

       Note

	       If  used  with  a  row-producing  procedure, this function should be called after all the rows from the procedure have been fetched
	      using ingres_fetch_array(3), ingres_fetch_object(3) or ingres_fetch_row(3). This function will eliminate any rows yet to be  fetched
	      should there be any left over.

PARAMETERS

	      o $result
		- The result identifier for a query

RETURN VALUES

	Returns an integer if there is a return value otherwise it will return NULL.

EXAMPLES

       Example #1

	      Get the return value from a procedure call

	      <?php

	      $link = ingres_connect($database);

	      if ( ingres_errno() != 0 ) {
		  $error_text = ingres_error();
		  die($error_text);
	      }

	      $result = ingres_query($link, "execute procedure php_proc (value = 1000)");

	      if ( ingres_errno() != 0 ) {
		  $error_text = ingres_error();
		  die($error_text);
	      }

	      echo "return value - " . ingres_fetch_proc_return($result) . "
";

	      ingres_close($link);

	      ?>

SEE ALSO

       ingres_query(3), ingres_fetch_array(3), ingres_fetch_object(3), ingres_fetch_row(3).

PHP Documentation Group 											       INGRES_FETCH_PROC_RETURN(3)