How to execute stored procedure in oracle with cursor as a out parameter

[SakthiPriya28]

Hi,
I have created a simple stored procedure in oracle10g that return a result set. I dont know how to execute that procedure by passing cursor as an argument. If there is a solution please post here. Thanks in advance.

My stored procedure is:

create or replace procedure sp1(cur out sys_refcursor)
as
begin
open cur for select * from tab1;
end;

[ramanan ram]

execute sp1;
only executing does't show output
using cur variable through for loop
inside dbms_output.put _line();

[SakthiPriya28]

Thank u for ur reply.