Hi, I am using following code and some time DataAdpter threw "Common Language Runtime detected an invalid program." Error while Adapter Fill.
public DataSet USP_SELECT_INSERT_UPDATE_FILE(int p_GL_Code, string P_FILE_TYPE, int P_Entity_Gl_Code, string P_Ref_No, int P_File_Server_Gl_Code, string P_OverWrite, string P_File_Path, string P_File_Name, int P_PersonGlCode, string P_Action)
{
DataSet dsResult = new DataSet();
OracleConnection conn = new OracleConnection();
OracleDataAdapter adp = null;
try
{
using (conn = new OracleConnection(strConnection))
{
OracleCommand cmd = new OracleCommand("USP\_SELECT\_INSERT\_UPDATE\_FILE", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.BindByName = true;
cmd.Parameters.Clear();
cmd.Parameters.Add("p\_GL\_Code".ToUpper(), OracleDbType.Int32, p\_GL\_Code, ParameterDirection.Input);
cmd.Parameters.Add("P\_FILE\_TYPE".ToUpper(), OracleDbType.NVarchar2, P\_FILE\_TYPE, ParameterDirection.Input);
cmd.Parameters.Add("P\_Entity\_Gl\_Code".ToUpper(), OracleDbType.Int32, P\_Entity\_Gl\_Code, ParameterDirection.Input);
cmd.Parameters.Add("P\_Ref\_No".ToUpper(), OracleDbType.NVarchar2, P\_Ref\_No, ParameterDirection.Input);
cmd.Parameters.Add("P\_File\_Server\_Gl\_Code".ToUpper(), OracleDbType.Int32, P\_File\_Server\_Gl\_Code, ParameterDirection.Input);
cmd.Parameters.Add("P\_OverWrite".ToUpper(), OracleDbType.NVarchar2, P\_OverWrite, ParameterDirection.Input);
cmd.Parameters.Add("P\_File\_Path".ToUpper(), OracleDbType.NVarchar2, P\_File\_Path, ParameterDirection.Input);
cmd.Parameters.Add("P\_File\_Name".ToUpper(), OracleDbType.NVarchar2, P\_File\_Name, ParameterDirection.Input);
cmd.Parameters.Add("P\_PersonGlCode".ToUpper(), OracleDbType.Int32, P\_PersonGlCode, ParameterDirection.Input);
cmd.Parameters.Add("P\_Action".ToUpper(), OracleDbType.NVarchar2, P\_Action, ParameterDirection.Input);
cmd.Parameters.Add("C\_Status".ToUpper(), OracleDbType.RefCursor, ParameterDirection.Output);
cmd.Parameters.Add("c\_Result".ToUpper(), OracleDbType.RefCursor, ParameterDirection.Output);
cmd.CommandTimeout = intTimeOut;
adp = new OracleDataAdapter(cmd);
conn.Open();
**adp.Fill(dsResult); /****_\*_** **Some time Here Adapter give Common Language Runtime Error \*/**
}
}
catch (Exception ex)
{
Common\_Functions.SaveErrorLogDaily("Message : " + ex.Message + " StackTrace : " + ex.StackTrace);
throw ex;
}
finally
{
conn.Close();
conn.Dispose();
adp.Dispose();
}
return dsResult;
}