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