ingres_fetch_proc_return

(PECL ingres >= 1.4.0)
Get the return value from a procedure call
int ingres_fetch_proc_return ( resource $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.

Parameters:
result

The result identifier for a query

Returns:

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

Examples:
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);

?>

See also:

ingres_query() -

ingres_fetch_array() -

ingres_fetch_object() -

ingres_fetch_row() -

doc_php
2016-02-24 16:16:59
Comments
Leave a Comment

Please login to continue.