Re: PL/SQL procedure problem

Garry , try END LOOP instead of END c1.

Darren Earl. (darren_at_earld.demon.co.uk)

"Gary G" <ggorbon1_at_swarthmore.edu> wrote:

>I have tried to create a procedure, and can't seem to be able to compile
>it. At this point I've tried just about everything, and not sure if I'm
>missing an obvious error in script, or the problem is at the back end. Here
>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;
>/
 

>-- and this is the message I get at SQL prompt
 

>>Warning: Procedure created with compilation errors.
 

> real: 160
>Input truncated to 24 characters

> Any thoughts on this matter?
>Thanks
>Gary
Received on Mon Dec 02 1996 - 00:00:00 CET