title: Spring MVC - Executing an Oracle Stored Procedure using java?
body: <p>I have a JDBCTemplate connection and a NamedParameterJdbcTemplate connection variable between my Spring MVC application and an Oracle database. I also have a stored procedure in the Oracle database that takes either a 0 or 1 as an input parameter, and does not return anything upon completion. </p>
  
  <p>I need help understanding how to execute this stored procedure. </p>
  
  <p>Eventually I will need to send this execution to a thread to complete without having the user to sit and wait, but I need to get this step first.</p>
  
  <p>I have looked at the other questions on the site for help and it feels like the explanations aren't giving me anything I can work with. So I need any advise that can be offered.</p>
  
  <p>All I have is this so far which isn't even correct:</p>
  
  <pre><code>    public void processRetrosToEpay() throws SQLException{
          //CallableStatement cs = spaeJDBCTemplate.prepareCall("RP_RETRO_PROCESS(?)");
          //cs.execute();
      }
  </code></pre>