I'm trying to use a substitution variable inside a
loop, but instead of prompting me each iteration in
the loop, it prompts me only the first time and uses
the same value for the duration of the loop.

How do you make it prompt each time through the loop?

I don't think your question is related to DB Tools SQL Editor or other software made by SoftTree Technologies. If you are inquiring about SQL*Plus please contact Oracle Corp. That makes that software tool.

: I'm trying to use a substitution variable inside a
: loop, but instead of prompting me each iteration in
: the loop, it prompts me only the first time and uses
: the same value for the duration of the loop.

: How do you make it prompt each time through the loop?