At 01:06 PM 7/03/2005 +0100, you wrote:

>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??

What do you mean by "all values"? Do you actually mean "all rows", i.e. you
remove all criteria?

Advice: use the explicit join syntax. It is a lot easier to troubleshoot
-- and also a bit more likely that you will remember to use fully qualified
names for EVERYTHING in join sentences:

FOR select a.field1, a.field2, b.field3
from tab1 a
join tab2 b
ON a.id = b.id
/*
WHERE a.crit1 = '1002'
and ...<more qualified criteria>
*/
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

./hb

>Thanks in advance!
>
>Nicolas
>
>
>
>
>Yahoo! Groups Links
>
>
>
>