In your refcursor you demonstrate:
open x for select * from emp;

what happens if we had a refcursor such as:
open x for select .... from emp, dept, address where ....;

how do we define:
a emp%rowtype; ????

Thank you for your time and help.