I have a procedure which gives OUT PL/SQL table. I would like to know, if I can generate a report using those PL/SQL table. I am using Crystal Reports 8.0


For reference I have included the PL/SQL Table definitions.


CREATE OR REPLACE PACKAGE PKG_Employee AS
TYPE EmployeeRecordType IS RECORD(
EmployeeNumber NUMBER,
LastName VARCHAR2(30),
FirstName VARCHAR2(30),
MiddleInitial VARCHAR2(1),
SocialSecurityNumber VARCHAR2(9),
DateOfBirth DATE,
EffectiveDate DATE,
TermDate DATE);
TYPE EmployeeTableType IS TABLE OF EmployeeRecordType
INDEX BY BINARY_INTEGER;
PROCEDURE employeeReport
(i_Deptno IN NUMBER,
o_EmployeeTable OUT EmployeeTableType);
END;
/

Thanks