Re: brain dead FOR LOOP gotcha

Mark C. Stock wrote:
> been pounding my head on my desk trying to figure out why a test
script was
> not working -- it was just a simple loop like this one that called a
stored
> procedure with the value returned by the for loop
>
> SQL> declare
> 2 n_dummy number;
> 3 n_count number default 0;
> 4 begin
> 5 for r1 in (
> 6 select deptno
> 7 into n_dummy
> 8 from dept
> 9 )
> 10 loop
> 11 n_count := n_count + 1;
> 12 dbms_output.put_line(n_count ||') '||n_dummy);
> 13 end loop;
> 14 end;
> 15 /
>
> Results:
> 1)
> 2)
> 3)
> 4)
>
> it would run, but always appear to return NULL for the selected value
...
> can you spot the problem? when i finally did i wasn't sure who was
more
> brain-dead, me or pl/sql.
>

Of course, one might demand you reference the contents of the cursor appropriately? As in:

        dbms_output.put_line(n_count ||') '||r1.deptno);

But you're right: a syntax error would have been nice. <gripe>Particularly from a piece of software that is smart-arsed enough to tell me I forgot the "from" when I mistype it as "form" but dumb enough not to correct it for me... (/gripe> Received on Thu May 05 2005 - 20:00:13 CDT