How can return table of records by using the procedures in plsql

I am writing the procedure as

   create or replace procedure my_proc(limit_value in number,.........)
   is
       cursor...................
       .........................
   begin
       open ...;
       loop
         .....
         .....
       close ....;
   end my_proc;

I want to generate the reports who are开发者_JAVA技巧 having the salary less than limit value.

Is it possible to get the table records with OUT parameter to generate the reports?

If it is possible, please explain

---

Yes, you can. You can even do it with the return value of the procedure / function:

create or replace type salary_rec as object (
    emp_id number
    salary number
);

create or replace type t_salary as table of salary_rec;

create or replace function retrieve_emp(
    i_max_salary number
) return t_varchar_number
as
    result t_salary;
begin
    select salary_rec(emp_id, salary) bulk collect into result
    from emp_salary
    where salary <= i_max_salary;

    return ret;
end;
/

That's just one of many variations of BULK COLLECT and of the different table types in Oralce and PL/SQL.