Re: PL/SQL procedure problem

In article <01bbdc74$d0092d40$0e433a82_at_gorbonosov.swarthmore.edu>, ggorbon1_at_swarthmore.edu says...
> I have tried to create a procedure, and can't seem to be able to
 compile
> is a bare bones version of the needed procedure:
>
> CREATE OR REPLACE PROCEDURE label AS
>
> CURSOR c1 IS SELECT apbcons_addr_name,
> from apbcons;
>
> BEGIN
> FOR c1rec IN c1 LOOP
> INSERT INTO label_run (name)
> VALUES (c1rec.apbcons_addr_name);
> END c1;
> END;
> /
>
>
>
Change end c1; to end loop;
Fran Received on Wed Nov 27 1996 - 00:00:00 CET