title: Index Out of Range Exception (No Row at Position 0)
body: <p>I'm tring to call a stored procedure into a ActionResult from the view model.</p>
  
  <p>When I tried to run my code I get an error </p>
  
  <blockquote>
    <p><em>IndexOutOfRangeException was handled by user code - No Row at Position 0</em></p>
  </blockquote>
  
  <p>This is a newly created table and is empty but why isn't the stored procedure getting fired to insert the data?  Here is my code.</p>
  
  <p><strong>Called Procedure CreateSecureRequestOutcome</strong></p>
  
  <pre><code> public static void CreateSecureRequestOutcome(
   OracleTransaction trans,
   dsAdmin.SECURE_REQUEST_OUTCOMESRow outcomeRow)
    {
     using (OracleCommand cm = new OracleCommand())
    {
     cm.Connection = trans.Connection;
     cm.Transaction = trans;
     cm.CommandText = "TheService.PKG#SECURE_REQUEST.SECURE_REQUEST_OUTCOME";
     cm.CommandType = CommandType.StoredProcedure;
     cm.AddToStatementCache = true;
  
   OracleParameter param = cm.Paramaters.Add("P_KEEP_PERSON_ID", OracleDBType.Decimal, Paremeter.Direction.Input);
   param.Value = keepPersonID;
  
   param = cm.Paramaters.Add("P_SECURE_REQUEST_GUID", OracleDBType.Raw, 16, null, Paremeter.Direction.Input);
   param.Value = outcomeRow.SECURE_REQUEST_GUID;
  
   param = cm.Parameters.Add("P_OUTCOME_TIMESTAMP", OracleDBType.Object, Paremeter.Direction.Output);
    }
  }
   cm.ExecuteNonQuery();
  </code></pre>
  
  <p><strong>IdentityConfirmed ViewModel Controller</strong></p>
  
  <pre><code>[httpPost]
  public ActionResult IdentityConfirmed(FormCollection collection)
  {
   dsAdmin.SECURE_REQUESTS_OUTCOMESRow secReqOutRow;
  
  using (OracleConnection cn = new OracleConnection (OracleConnectionManager.GetProxyServiceConnetionString()))
  {
      cn.Open();
      using (OracleTransaction trans = cn.BeginTransaction())
      {
            using (Data.dsAdminTableAdapters.SECURE_REQUESTS_OUTCOMESTableAdapter taOut = new Data.dsAdminTableAdapters.SECURE_REQUESTS_OUTCOMESTableAdapter();
            {
               typedDatasetFiller.ApplyConnection(taOut, cn);
               secReqOutRow = taOut.GetDataBySecureGUID(request.ToByteArray())[0];
            }
              secReqOutRow.OUTCOME_TIMESTAMP = DateTime.Now.AddMonths(1);
              Support.CreateSecureRequestOutcome(trans, secReqOutRow);
              trans.Commit();
        }
      cn.Close();
    }
   retrun View("IdentityConfirmed", vm);
  }
  </code></pre>