Name
exec_result — Returns a result set row to the calling procedure context
Synopsis
any exec_result ( |
in res_values_array any
); |
Description
This function returns a result set row to the calling procedure's context, whether it is the client, exec function or a procedure view). The row's values are the elements of the supplied res_values_array vector.
Parameters
res_values_array
This parameter can be one of two things:
| a vector of strings (like vector('cola', 'colbb')). When used that way it makes columns named 'cola' and 'colb' with type ANY and precision 256 |
an array with the same format as the 0th element of the
metadata returned by exec() and
rexec() , which contains all the type
information and can be used directly. |
Return Types
The row's values are the elements of the supplied
res_values_array vector. For example: exec_result (vector (1, 'a')) will return a
row of two columns: 1 and 'a'. This is similar to the result() function, but it uses an array instead
of parameter list
Examples
Example24.103.Result set rows
create procedure XX1 ()
{
declare meta, _dt any;
declare inx integer;
exec ('select U_ID, U_NAME from SYS_USERS', null, null, null, 0, meta, _dt);
inx := 0;
exec_result_names (meta[0]);
while (inx < length (_dt))
{
exec_result (_dt[inx]);
inx := inx + 1;
}
};