Skip to Main Content

Java SE (Java Platform, Standard Edition)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ASP.NET Oracle.ManagedDataAccess.Client OracleDataAdapter threw Common Language Runtime Error

User_ADDTNMay 3 2021

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;  

}

Comments

Processing

Post Details

Added on May 3 2021
0 comments
334 views