PL/SQL-how to create a procedure that return a record?

What should i do to return a record from a procedure or fonction or what ever..

A query like this :

SELECT emp.*, dept.*
FROM emp, dept
WHERE emp.deptid = dept.deptid
AND emp.empid = param_EmpID

param_EmpID is a IN var that a pass to the procedure.

How can a do that? Received on Sat Jun 13 1998 - 00:00:00 CDT