below is the PL/SQL code in which i m passing the parameters to the cursor.What i want is how to put the logic inside the PL/SQL to view the result
Code:Declare Cursor emp_cur ( p_id number,p_name varchar2 ) is SELECT empno,ename FROM EMP WHERE EMPNO= p_id and ENAME=p_name; BEGIN OPEN emp_cur ( 7521,'WARD'); CLOSE emp_cur; END; /