SQL & PL/SQL

Dear All,
I want to print a resultset ( table ) immediately after the execution of a procedure in PL/SQL.

Ex:
create or replace proc_name as
begin
select empno,empname from employee;
end;

Is it possible in Oracle ? ( possible in SQL Server)


Note:

We can Achieve it by
Declaring Out Parameter and print in table format using dbms_output.put_line and
Delcaring Our Cursor Variable and print the result.
I want some other methods to achieve it...

Thank u and with regards,
Hariharan .ST