wb_psql_drop_params
boolean wb_psql_drop_params( resource psql )
Parameters
-
psql
- Identifier of a prepared SQL statement, the result of the wb_psql_prepare function. Mandatory parameter.
Description
This function cancels the currently sent IN and INOUT parameter values and prepares the SQL Server to receive new parameter values. This function can only be used when the SQL statement has nott been executed yet and some values of the IN and INOUT parameters have already been sent to the SQL Server (using the wb_psql_send_param function).
Returns
TRUE if successful, otherwise FALSE.
Example
Send an IN parameter value to the SQL Server, cancel the value, send another value, execute the statement 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_drop_params($psql);
wb_psql_send_param($psql,1,321);
wb_psql_execute($psql);
echo "name=".wb_psql_get_out_param($psql,0)."\n";
Viz
