Connect programmer/p@9i


create or replace procedure Open_Close_5_Different is
    cursor cur001 is select '001' from dual;
    cursor cur002 is select '002' from dual;
    cursor cur003 is select '003' from dual;
    cursor cur004 is select '004' from dual;

    cursor cur005 is select '005' from dual;
  begin
    open  cur001;
    close cur001;
    open  cur002;
    close cur002;

    open  cur003;
    close cur003;
    open  cur004;
    close cur004;
    open  cur005;
    close cur005;
end Open_Close_5_Different;

/
Show Errors