Hi,

I´ve got problems using a cursor.

Syntax is like:

FOR select a.field1, a.field2, b.field3
from tab1 a, tab2 b
where a.id = b.id
and crit1 = '1002'
and ...
group by a.field1, a.field2, b.field3
into :v_field1, v:field2, :v_field3 DO

begin
insert into new_tab
(field1, field2, field3)
values
(:v_field1, v:field2, :v_field3);
end
end

As long as crit1 is given there´s no problem. As soon as I select all
values this proc doesn´t work anymore and nothing is written into new_tab.

Any idea??

Thanks in advance!

Nicolas