Name

exec_result_names — Supplies column details for procedure result set output.

Synopsis

exec_result_names ( in res_names_array any );

Description

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() .

Parameters

res_names_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

None.

Examples

Example24.104.Result set column names

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

See Also

exec()

rexec()

exec_result()