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: Procedure error

Re: Procedure error

From: James Agostinho <tvwatchr_at_ix.netcom.com>
Date: Fri, 6 Dec 2002 08:57:06 -0800
Message-ID: <asqkt0$412$1@slb6.atl.mindspring.net>


Sybrand Bakker,
Thanks, I took the offending line out and it worked perfectly, Thanks again.
James
"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:a9j1vuoqt7osqlmg5c9n1s1ubk87srtf2n_at_4ax.com...
> On Fri, 6 Dec 2002 06:40:36 -0800, "James Agostinho"
> <tvwatchr_at_ix.netcom.com> wrote:
>
> >Can anyone please look at this and give me any suggestions?
> >I've enclosed the error and then the text of the procedure.
>
>
> You are using ln as indicator variable in your for loop *and* you are
> incrementing/assigning into it. The variable is already incremented
> automatically and you can't assign to indicator variables (which is
> what the error message tells you, and the text in the error messages
> manual explains in more detail). Unless you want a side effect (you
> want to increment with 2 in which case you can't use FOR but need
> WHILE) you can safely remove ln := ln + 1
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Fri Dec 06 2002 - 10:57:06 CST

Original text of this message

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