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; } };