Hi all,

M create a procedure which will return the matching value .
when m creating the procedure is beging crerated but its throwing an error while excuating...

here is the script

Create or replace Procedure get_dname_for_i d1
( i_dept_id in dept.deptno%typ e,
o_dname out dept.dname%type ) IS
begin
select dname
into o_dname
from dept
where...