Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Procedure error
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