Connect programmer/p@9i


create or replace procedure Open_Close_5_Same is
    -- This code subverts the benefit of the PL/SQL cursor cache
    -- 'cos there's many cursors for one SQL statement
    cursor cur001 is select 'same' from dual;
    cursor cur002 is select 'same' from dual;

    cursor cur003 is select 'same' from dual;
    cursor cur004 is select 'same' from dual;
    cursor cur005 is select 'same' from dual;
  begin
    open  cur001;
    close cur001;

    open  cur002;
    close cur002;
    open  cur003;
    close cur003;
    open  cur004;
    close cur004;
    open  cur005;

    close cur005;
    -- Good: opened cursors ARE closed.
end Open_Close_5_Same;
/
Show Errors