Hey all,when i am trying to create a package i am getting an error
PLS-00410: duplicate fields in RECORD,TABLE or argument list are not permitted
CREATE OR REPLACE PACKAGE plsql101_pack IS
DATE_LOADED DATE;
TYPE pkg_perform_type IS RECORD
(person_code plsql101_person.person_code%TYPE,
person_name CHAR(12),
current_sales NUMBER(8,2),
perform_percent NUMBER(8,1),
status CHAR(30)
);
CURSOR PKG_PER_CUR RETURN plsql101_person%ROWTYPE;
FUNCTION pkg_comp_discounts (order_amt NUMBER) RETURN NUMBER;
PROCEDURE pkg_compute_perform
(a_perform plsql101_person%ROWTYPE,
a_perform OUT pkg_perform_type);
END plsql101_pack;
/
SQL> @plsql101_pack
Warning: Package created with compilation errors.
SQL> SHO ERROR
Errors for PACKAGE PLSQL101_PACK:
LINE/COL ERROR
-------- -----------------------------------------------------------------
18/1 PL/SQL: Declaration ignored
18/1 PLS-00410: duplicate fields in RECORD,TABLE or argument list are
not permitted
can i know why i am getting the error..
Thanks in advance!!