wrong number or types of arguments in call to 'GET_DNAME_FOR_ID1.

[sonu173]

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 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.....

[Nepomuk]

Hi sonu!
This is the introductions area and not the place for technical questions. Those belong under topics -> the language you're using -> answers. If the language you're using isn't represented there, the Misc Section is the right place.

Now, in this case I don't know, which language it is you're using. Might be Delphi from what I know but as the error says something about SQL, maybe it's MySQL or something like that? If you tell us which language it is, I'm sure one of us mods will move it to the right section for you.

Greetings,
Nepomuk

[debasisdas]

The error message is self explanatory.

How are you calling the procedure ?