Re: PL/SQL procedure problem
From: Lluis Martinez <zlmartin_at_correu.gencat.es>
Date: 1996/11/28
Message-ID: <329DC2C7.6CB3_at_correu.gencat.es>#1/1
Date: 1996/11/28
Message-ID: <329DC2C7.6CB3_at_correu.gencat.es>#1/1
Gary G wrote:
> 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;
> /
Maybe END LOOP instead of END c1 ?
The compiler messages are clear as shit !
HTH,
Lluís
Received on Thu Nov 28 1996 - 00:00:00 CET