Re: PL/SQL procedure problem
From: Richard Garrett <richardg_at_parallax.co.uk>
Date: 1996/12/02
Message-ID: <01bbe02b$bd2bcb00$a70a10ac_at_zippy.parallax.co.uk>#1/1
Date: 1996/12/02
Message-ID: <01bbe02b$bd2bcb00$a70a10ac_at_zippy.parallax.co.uk>#1/1
You will also need to remove the erroneous comma after the column name in the cursor declaration.
CURSOR c1 IS SELECT apbcons_addr_name,
from apbcons;
Gary G <ggorbon1_at_swarthmore.edu> wrote in article
<01bbdc74$8658bc60$0e433a82_at_gorbonosov.swarthmore.edu>...
> I have tried to create a procedure, and can't seem to be able to compile
> it.
> 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;
> /
>
Received on Mon Dec 02 1996 - 00:00:00 CET