I would need to pass a parameter value to a cursor in a pl/sql procedure.
create or replace procedure test1
cursor c as select * from emp where emp_name = 'test'
instead of above can we do it this way ? I am getting an error with this approach can you please help with the correct syntax in doing or give me an example please.
create or replace procedure test1 (p_empname in varchar2(20))
cursor c as select * from emp where emp_name = p_empname