title: Spring JDBC Template. How can get outcome variables of the pl/sql script
body: <p>I am using NamedParameterJdbcTemplate for run pl/sql script. 
  But I don't know how can I get the values ​​of out variables (<strong>:id_out</strong>). 
  Thanks in advance.</p>
  
  <pre><code>String script = "declare 
                     begin 
                       if myFunc(:id_in) is null then 
                          :id_out := 0; 
                       else 
                          :id_out := 1; 
                       end if; 
                     end;";
  Map&lt;String,Object&gt; bindVars = new HashMap&lt;String, Object&gt;();
  bindVars.put(id_in,1);
  bindVars.put(id_out,2);
  
  
  jdbcTmpl.execute(script, bindVars, new PreparedStatementCallback&lt;Object&gt;() {
      @Override public Object doInPreparedStatement(PreparedStatement cs)
          throws SQLException, DataAccessException {
          cs.execute();
          return null;
                  }
         }
         );
  </code></pre>