Re: PL/SQL procedure problem

From: <seci_at_ludens.elte.hu>
Date: 1996/12/02
Message-ID: <1996Dec2.163721.34712_at_ludens>#1/1


In article <01bbdc74$8658bc60$0e433a82_at_gorbonosov.swarthmore.edu>, "Gary G" <ggorbon1_at_swarthmore.edu> writes:
> 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;

try

     END LOOP;
here
> END;
> /
>
> -- and this is the message I get at SQL prompt
>

>>Warning: Procedure created with compilation errors.
>

SHOW ERRORS
        will give you the error message and the place of error
> real: 160
> Input truncated to 24 characters
>
>
> Any thoughts on this matter?
> Thanks
> Gary
>

HTH
        peter Received on Mon Dec 02 1996 - 00:00:00 CET

Original text of this message