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_id1
( i_dept_id in dept.deptno%type,
o_dname out dept.dname%type ) IS
begin
select dname
into o_dname
from dept
where deptno = i_dept_id;
End;
/
Procedure created.
When m trying to excute its throwing the error......
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'GET_DNAME_FOR_ID1'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
please help me......
thanks,
sonu chadha.....