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

Popular posts from this blog

E-Text Report In Fusion | Types of E-Text reports

Supplier API's

How to pass default Parameter in cursor