>> I want to call a procedure on each of the returned rows, in the order returned. <<

SQL is a set-oriented language!!! Let's get back to the basics of an
RDBMS. Rows are not records; fields are not columns; tables are not
files; there is no sequential access or ordering in an RDBMS, so
"first", "next" and "last" are totally meaningless.

We need more info ..