Re: PL/SQL procedure problem

In article <01bbdc74$aa7daa60$0e433a82_at_gorbonosov.swarthmore.edu>, 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

We always put a period in column 1 on a line by itself before the /, but a blank line before the / should also work.

Also, after the / line, put the following line:   show errors procedure label

Finally, the "Input truncated..." message is generated in SQL Plus when you don't end the last line in your script with a Return.

Hope this helps
Steve Cosner Received on Wed Nov 27 1996 - 00:00:00 CST