Re: Using SP OUTPUT Procedure with .NET

Ryan Hunt wrote:

I am having troubles using output paramters in our .NET web code. If we
don't use the output params we are fine. Consider the following:

CREATE PROCEDURE WHATEVER (IN ID int, OUT ID2 int)
etc., etc.


When I call this from SQL scripts as CALL WHATEVER (1, NULL) it works fine.
However, in .NET we get an error indicating an incorrect number of paramters
was supplied.

I ran through a similar issue not too long ago. It turned out that the .NET guy had to set the value of the output parameter (to 0) or the database manager wouldn't pass the parameter to the SP (the RPG program behind the stored procedure saw NULL.)

cmd.Parameters.Add("rowCount", iDB2DbType.iDB2Integer).Value=0;
cmd.Parameters["rowCount"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
count = Convert.ToInt32(cmd.Parameters[7].Value);

--buck