©
This document uses PHP Chinese website manual Release
(PECL ingres >= 1.4.0)
ingres_fetch_proc_return — Get the return value from a procedure call
$result
)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() , ingres_fetch_object() or ingres_fetch_row() . This function will eliminate any rows yet to be fetched should there be any left over.
result
The result identifier for a query
Returns an integer if there is a return value otherwise it will
return NULL
.
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 ) . "\n" ;
ingres_close ( $link );
?>