conforme a imagem abaixo, eu vejo o pacote, com as procedures, clico nela pra executar e da o erro conforme imagem, alguém poderia me ajudar explicar o porque deste erro? Obrigado
Clique na imagem para aumentar
Eu inclui esta proc e pacote conforme segue
-- this script should be run as the HR schema.
-- this script creates the pl/sql package and
-- body necessary for the ref cursor demo app.
create or replace package otn_ref_cursor as
-- used to illustrate passing a ref cursor
-- as a return value from a function
-- or as an output parameter from a procedure
function get_emp_info return sys_refcursor;
procedure get_emp_info(p_rc out sys_refcursor);
procedure get_multiple_cursors(p_rc1 out sys_refcursor, p_rc2 out sys_refcursor, p_rc3 out sys_refcursor);
end;
/
create or replace package body otn_ref_cursor as
function get_emp_info return sys_refcursor is
-- declare the cursor variable
-- sys_refcursor is a built in type
l_cursor sys_refcursor;
begin
open l_cursor for
select employee_id,
last_name,
first_name,
to_char(hire_date, 'DD-MON-YYYY') hire_date
from employees
where last_name like 'A%'
order by last_name,
first_name;
return l_cursor;
end;
procedure get_emp_info(p_rc out sys_refcursor) is
begin
-- open the cursor using the passed in ref cursor
-- sys_refcursor is a built in type
open p_rc for
select employee_id,
last_name,
first_name,
to_char(hire_date, 'DD-MON-YYYY') hire_date
from employees
where last_name like 'A%'
order by last_name,
first_name;
end;
procedure get_multiple_cursors(p_rc1 out sys_refcursor, p_rc2 out sys_refcursor, p_rc3 out sys_refcursor) is
begin
-- open the cursors using the passed in ref cursor parameters
-- sys_refcursor is a built in type
open p_rc1 for
select employee_id,
last_name,
first_name,
to_char(hire_date, 'DD-MON-YYYY') hire_date
from employees
where last_name like 'A%'
order by last_name,
first_name;
open p_rc2 for
select employee_id,
last_name,
first_name,
to_char(hire_date, 'DD-MON-YYYY') hire_date
from employees
where last_name like 'B%'
order by last_name,
first_name;
open p_rc3 for
select employee_id,
last_name,
first_name,
to_char(hire_date, 'DD-MON-YYYY') hire_date
from employees
where last_name like 'C%'
order by last_name,
first_name;
end;
end;
/