ecpg aborts with structure reference

Поиск
Список
Период
Сортировка
От Tim Nelson
Тема ecpg aborts with structure reference
Дата
Msg-id 63BD6AB4FBBED411B3E20004ACAE8B6301445B@str_nt01.ecs-inc.com
обсуждение исходный текст
Список pgsql-interfaces
I've found this problem with "ecpg" (I even tried moving up to version 2.9)
where the code:

exec sql include    sqlca;

exec sql type  APC_LAYO_FLD is struct {  long apcl_id;  char apclf_sect_flg[2];
};

exec sql type  APC_LAYOUT is struct {  long apcl_id;
};

exec sql begin declare section;  APC_LAYOUT     PL;  APC_LAYO_FLD   PLF;
exec sql end declare section;
  int
print_template()
{
exec sql begin declare section;  char curr_sect[5];
exec sql end declare section;
  if (1) {        exec sql declare fld_curs cursor for           select apc_layo_fld.*              from apc_layo_fld
          where apcl_id = :PL.apcl_id                and apclf_sect_flg = :curr_sect           order by apclf_ln_nbr,
apclf_col_nbr; }     exec sql open fld_curs;
 
}

If I remove the "if", or change the structure reference ":PL.apcl_id" to
a constant it doesn't abort.  I think this has something to with the
"open" being outside of the block. I try and dig into the code a bit as time
permits.  Thanks.

Tim Nelson


В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Christof Petig
Дата:
Сообщение: ECPG bug: allocate descriptor does not clear sqlcode
Следующее
От: Christof Petig
Дата:
Сообщение: Re: ECPG bug: allocate descriptor does not clear sqlcode