title: Incorrect number of arguments for PROCEDURE; expected 1, got 0. Cant determine the error from code
body: <p>//set input parameters</p>
  
  <pre><code>Map&lt;String,Object&gt; inParams = new HashMap&lt;String,Object&gt;();
  inParams.put("Sig",resourceHistoryBean.getId());
  
  List&lt;ResourceHistoryBean&gt; resourceHistoryList= new ArrayList&lt;ResourceHistoryBean&gt;();
  </code></pre>
  
  <p>// define stored procedure</p>
  
  <pre><code>try{        
      SimpleJdbcCall readResult = new SimpleJdbcCall(getDataSource())
              .useInParameterNames("Sig")
              .declareParameters(new SqlParameter("Sig", Types.VARCHAR))
              .withProcedureName("SP_ResourceAllocationDtls")
              .withSchemaName("hrms")
              .returningResultSet("ResourceHistory", new ParameterizedRowMapper&lt;ResourceHistoryBean&gt;() {
                  public ResourceHistoryBean mapRow(ResultSet rs, int rowNum)
                          throws SQLException {
                      ResourceHistoryBean bean = new ResourceHistoryBean();
                      resourceHistoryBean.setProjectName(rs.getString(RH_PROJECT_NAME));
                      return bean;
                  }
              });
      readResult.compile();
  </code></pre>
  
  <p>// execute stored procedure</p>
  
  <pre><code>Map&lt;String, Object&gt; out = readResult.execute(inParams);
  resourceHistoryList = (List&lt;ResourceHistoryBean&gt;) out.get("ResourceHistory");
  </code></pre>