PLS-00410: duplicate fields in RECORD,TABLE or argument list are not permitted
PLS-00410:
duplicate fields in RECORD,TABLE or argument list are not permitted
--============================================================
CREATE OR REPLACE PROCEDURE APPS.XXSD_ERROR_FINDER_PROC (
RETCODE OUT VARCHAR2,
ERRBUF OUT VARCHAR2,
P_DEPTNO IN VARCHAR2
)
AS
--P_DEPTNO VARCHAR2; ( Due to define same name of argument or Parameter Or Variable this ---- error comes)
cursor c1 is
select * from scott.emp
where deptno = P_DEPTNO;
BEGIN
for i in C1 loop
dbms_output.put_line (I.EMPNO);
end loop;
END;
Comments
Post a Comment