title: Not properly calling a Stored procedure?
body: <p>I have an oracle stored procedure which is working fine on sqldeveloper inserting record.
  How can i call it from asp.net? I have seen other solutions as well not helpfull.</p>
  
  <pre><code>OracleConnection objConn = new OracleConnection(_db.ConnectionString);
   objConn.Open();
   OracleCommand cmd = new OracleCommand("INSERTDOCUMENT", objConn);
  cmd.CommandType = CommandType.StoredProcedure;
   cmd.Parameters.Add("TMPLT_ID", OracleDbType.Decimal).Value = _schema.ID;
  ...
  cmd.ExecuteNonQuery();
  objConn.Close();
  </code></pre>
  
  <p>Someone please tell me what i am doing wrong?</p>