ТЕМА:

Piston пишет:

Super пишет: OK. FOR cursor LOOP executes in own context. That's why the above doesn't see any open cursors while

Все прозаично
5 declare
6 sql_text varchar2(1000);
7 begin
8 for v_rec in (
9 select sql_text
10 from v$open_cursor
11 ) loop
12 dbms_output.put_line(sql_text);
13 end loop;
14 end;