PL/SQL procedure problem

From: Gary G <ggorbon1_at_swarthmore.edu>
Date: 1996/11/27
Message-ID: <01bbdc74$aa7daa60$0e433a82@gorbonosov.swarthmore.edu>#1/1

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 Wed Nov 27 1996 - 00:00:00 CST