SQL>
create or replace procedure hello_p
as
c1 sys_refcursor;
being
open c1 for
select host_name,instance_name from gv$instance;
dbms_sql.return_result(c1);
end;
/
SQL> exec hello_p;
declare
host varchar2(500);
begin
select host_name into host from v$instance;
dbms_output.put_line(host);
end;
/
