-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|