title: Insert in Oracle Data Acces with C#
body: <p>Im trying to insert in a oracle table with this code, and thows this error message: "The value is not within the expected range."</p>
  
  <p>I have tried different ways but always throws the same error.</p>
  
  <pre><code>oc.Open();
  
  OracleDataAdapter oda = new OracleDataAdapter();
  
  
  
  OracleCommand cmd = new OracleCommand("INSERT INTO MYTABLE (ROW_ID, CREATED, STATUS) " +
     "VALUES (:pROW_ID, :pCREATED, :pSTATUS", oc);
  
  
  OracleParameter ROW_ID = new OracleParameter("pROW_ID", OracleDbType.Varchar2, 15, "ROW_ID");
  OracleParameter CREATED = new OracleParameter("pCREATED", OracleDbType.Date, 30, "CREATED");
  OracleParameter STATUS = new OracleParameter("pASIGNADO", OracleDbType.Varchar2, 15, "STATUS");
  ROW_ID.Value = BDOracleObtenerRowIDBackOffice();
  
  ROW_ID.Value = = "146721030020001";
  CREATED.Value = "SYSDATE";
  STATUS.Value = "ON_HOLD";
  
  cmd.Parameters.Add("pROW_ID", ROW_ID);  //&lt;-- Here throws exception
  cmd.Parameters.Add("pCREATED", CREATED);
  cmd.Parameters.Add("pSTATUS", STATUS);
  
  oda.InsertCommand = cmd;
  </code></pre>
  
  <blockquote>
    <p>Trace:
       at Oracle.ManagedDataAccess.Client.OracleParameter..ctor(String parameterName, Object obj)
       at Oracle.ManagedDataAccess.Client.OracleParameterCollection.Add(String name, Object val)
       at TestCore.MyClass.functionInsert(String param) at C:\Users\user_01\source\repos\file.cs:línea 2945</p>
  </blockquote>