Not sure which OracleCommand method to use
Posted: Tue 29 Apr 2014 13:17
I need to execute a stored procedure that does a whole bunch of work and returns several "out" parameters, but none of them are cursors or result sets (all scalar values.) My code looks like this:
I don't know if ExecuteScalar will return all of the "out" parameters, of if I should use another method.
Anyone that knows the answer, please help.
Thanks,
Peter
Code: Select all
OracleCommand command = GetStoredProcCommandAndConnection("IP_APP_PKG.QUICKENTRY_ENTERPAYCHECK");
command.Parameters.Add("p_pclient_id", OracleDbType.Number, Convert.ToDecimal(pClientId),
ParameterDirection.Input);
command.Parameters.Add("p_userid", OracleDbType.Number, Convert.ToDecimal(userId),
ParameterDirection.Input);
command.Parameters.Add("p_employeename", OracleDbType.VarChar, employeename,
ParameterDirection.Input);
command.Parameters.Add("o_pagenmumber", OracleDbType.Number, dPageNumber,
ParameterDirection.InputOutput);
command.Parameters.Add("o_no_of_pages", OracleDbType.Number, dNumberOfPages,
ParameterDirection.Output);
command.Parameters.Add("o_ppagesize", OracleDbType.Number, dPageSize,
ParameterDirection.Output);
command.Parameters.Add("o_totalemployees", OracleDbType.Number, dTotalEmployees,
ParameterDirection.Output);
command.Parameters.Add("o_sortorder", OracleDbType.VarChar, sortOrder,
ParameterDirection.Input);
command.Parameters.Add("o_message", OracleDbType.VarChar, ParameterDirection.Output);
command.ExecuteScalar(); // TODO: Is this the right method to execute?
Anyone that knows the answer, please help.
Thanks,
Peter