Specified Cast not Valid.. Stored procedure

cbeebe79

Hi.

Simple question: I have a stored proc that has an output of @oRetVal.

I have it coded as such:

sql.Parameters.Add("@oRetVal", SqlDbType.Int).Value = 0;
               
sql.Parameters["@oRetVal"].Direction = ParameterDirection.Output;

After I execute the proc I have:

int retVal;

retVal = (int)sql.Parameters["@oRetVal"].Value;

But I am getting the error: "Specified cast is not valid"

I am not sure what the issue is. The variable is created as an int and the actual param is an int. What am I doing wrong here?

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

cbeebe7916y ago
Thanks for the reply. I actually changed the parameter to this:
sql.Parameters["@oRetVal"].Direction = ParameterDirection.InputOutput

and it solved the problem. It's amazing that the simple problems are the ones that can slow you down the most, lol.

Regards
PJ Martins16y ago
try this instead:
retVal = Convert.ToInt16(sql.Parameters["@oRetVal"].Value);