602SQL Documentation Index  

wb_psql_out_param_count

PHP

int wb_psql_out_param_count( resource psql )


Parameters

psql
Identifier of a prepared SQL statement, the result of the wb_psql_prepare function. Required parameter.


Description

This function returns the count of OUT and INOUT parameters of the prepared SQL statement. The SQL statement with the psql identifier must have already been executed succesfully by the wb_psql_execute function.



Returns

Returns the count of the OUT and INOUT parameters of the SQL statement if succesful, otherwise FALSE.



Example

Send an IN parameter value to the SQL server, execute the statement, get the count of OUT parameters and read the OUT parameter value.

$psql=wb_psql_prepare($connection,"SELECT name INTO ? FROM Person WHERE ID=?");
wb_psql_send_param($psql, 1 /*second parameter*/, 123 /*parameter value*/);
wb_psql_execute($psql);
echo "count of OUT parameters: ".wb_psql_out_param_count($psql)."\n";
echo "name=".wb_psql_get_out_param($psql,0)."\n";    

Viz