Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL procedure problem

Re: PL/SQL procedure problem

From: Kristin S.Clayton <kclayton_at_brauntech.com>
Date: 1996/11/27
Message-ID: <329C9CC5.4F04@brauntech.com>#1/1

Gary G 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
>
> Any thoughts on this matter?
> Thanks
> Gary

 Use the 'show errors' command to get more info.

-- 
+----------------------------------------------------------------------------+
|  Kristin S. Clayton                     Phone:  312-443-1318
x227          |
|  Braun Technology Group                   Fax: 
312-443-1279               |
|  30 E. Monroe St, Suite 300            E-Mail: 
kclayton_at_brauntech.com     |
|  Chicago, IL 
60603                                                        |
+----------------------------------------------------------------------------+
Received on Wed Nov 27 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US