Hi Dave,
I think the 'FOR var in SQL-STATEMENT' can only be used if 'var' is a
record or a %ROWTYPE.
declare
...
v_stale_file_row static_pages%ROWTYPE;
or
v_stale_file_row record;
...
begin
...
for v_stale_file_row in
select ...
loop
perform static_page__delete(v.stale_file_row.static_page_id);
end loop;
...