If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

create or replace package attendance
as
type att_cur is ref cursor;
procedure get_single_entry(v_sdate in date, v_edate in date, s_cursor in out att_cur);
end attendance;

create or replace package body attendance
as
procedure get_single_entry(v_sdate in date, v_edate in date, s_cursor in out att_cur)
as
lv_record_to_date date;
begin
open s_cursor for
select record_to_date,record_to_date from
l_sec_account where record_to_date between v_sdate and v_edate;
loop
fetch s_cursor into lv_record_to_date, lv_record_to_date;
exit when s_cursor%notfound;
dbms_output.put_line('lv_record_to_date'||lv_record_to_date);
end loop;
end get_single_entry;
end attendance;