PLSQL using cursors or functions to query repeated data
This is a 4th option, using out parameters?

create or replace function getLicenseStatus
    (in_license_no varchar2, l_status out varchar2, l_status_dt out varchar2)
    as
begin
    SELECT status, status_dt 
       into into l_status, l_status_dt 
    from tbl_license 
    where licence_no=in_license_no;
end;