I have a simple procedure:
1 - now if in Toad (126.96.36.199) I set a breakpoint at first line (for r_list in) and invoke a debugger and try to go through code line by line (shift-f7) it does not go inside this "for loop" and goes straight to end loop.
CREATE OR REPLACE procedure MY.my_temp
for r_list in (
select first, last, data, city, socnum, count(*) from person
and socnum= '112233445566'
group by first, last, data, city, socnum having count(*) > 1
--select '' first, '' last, '' data, '' city, '' socnum from dual
dbms_output.put_line('test: ' || r_list.socnum);
2 - when I copy the content of this procedure to sql worksheet and I run the code through f9, I can see the dbms_output.put_line fine
3 - when I comment that select statement and uncomment the
and invoke the debugger and go through code line by line, all is OK, I get inside the "for loop" fine
"select '' first, '' last, '' data, '' city, '' socnum from dual"
What is going on or what am I missing?
[Updated on: Tue, 06 October 2020 06:53]
Report message to a moderator