Re: PL/SQL procedure problem

> >I have tried to create a procedure, and can't seem to be able to compile
> >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;
 Try replacing this line with "END LOOP;"
> >END;
> >/

HTH, Jim Mitchell
jmitch_at_clark.net Received on Wed Nov 27 1996 - 00:00:00 CET