public static int Merge(Issuer IssuerData)
{
DataRequest oRequest = new DataRequest(“PKG_NAME.ProcName”);
oRequest.CommandType = CommandType.StoredProcedure;
oRequest.Parameters.Add(new DataRequest.Parameter(“p_InParam1″, IssuerData.IssuerCode));
oRequest.Parameters.Add(new DataRequest.Parameter(“p_InParam2″, IssuerData.IssuerName));
oRequest.Parameters.Add(new DataRequest.Parameter(“p_InParam3″, IssuerData.NonVotingShares.ToString()));
oRequest.Parameters.Add(new DataRequest.Parameter(“p_CRDT_RPT_DT”, IssuerData.CreditReportDate.HasValue?IssuerData.CreditReportDate.Value.ToString(“dd-MMM-yy”):”" ));
OracleParameter outParam = new OracleParameter(“p_NUM_RECS_AFFECTED”, OracleDbType.Decimal, ParameterDirection.Output);
oRequest.Parameters.Add(outParam);
ORADataFactory oFactory = new ORADataFactory();
oFactory.ExecuteNonQuery(oRequest);
int numRecsAffected = 0;
int.TryParse(outParam.Value.ToString(), out numRecsAffected);
return numRecsAffected;
}
