This function allows you to define the column details for result sets returned by procedures, in particular for use with the exec() function. This function is similar to result_names().
None.
The procedure below uses the metadata from exec() to generate result set column names.
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;
}
};