ODP.NET

Hi friends,

I have a procedure
procedure sam(x varchar2,id number,val varchar2)
as
c number;
begin
if(x = 'data') then
select count(*) int c from emp where ID = id;
end;
if(x = 'basic') then
select count(*) int c from emp where ID = id;
end if;

if(c = 0) then
val:='Yes';
else
val:='No';
end if;
end;

There is no problem with the procedure

Code that calls from C#.net

OracleCommand cmd = new OracleCommand("TOOLS.CheckPrevData",(OracleConnection)con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("x",OracleDbType.Varchar2,System.Data.ParameterDirection.Input);
cmd.Parameters["Filetype"].Value = "data";
cmd.Parameters.Add("id",OracleDbType.Int32 ,System.Data.ParameterDirection.Input);
cmd.Parameters["Product_ID"].Value = 123456789;
OracleParameter param = cmd.Parameters.Add("Val",OracleDbType.Varchar2,System.Data.ParameterDirection.Output);
cmd.ExecuteNonQuery();

When i execute the c# code it throws the below exception at cmd.ExecuteNonQuery()

ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "PROC", line 910 ORA-06512: at line 1

Someone please help me !!!!!