Hello,
I can observe the current value of a bind variable, using v$sql_bind_capture. I don't know how to do it, when having no bind variable.
Having a simple code like this below, I would like to see a VALUE of rec.column1 being passed to my_function.

begin
  for rec in (select column1 from tab_A) loop
    my_function(rec.column1);
  end loop;
end;

How to achieve that starting from v$session? There are no obvious bindings here.
When running long executing scripts, I would like to spy and verify where I am with the execution.

begin
  for rec in (select column1 from tab_A) loop
    dbms_application_info.set_client_info('Currently on '||i.column1);
    my_function(rec.column1);
  end loop;
end;