title: Caused by: java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'PR_SP_FAHMI'
body: <p>I have java file which use to execute Store Procedure by using SimpleJdbc like in the below code :</p>
  
  <pre><code>@Transactional(propagation = Propagation.REQUIRED, rollbackFor = {SQLException.class, Exception.class })
  public void executeSPForInsertData(DataSource ds,String procedureName,Map&lt;String, Object&gt; inputParameter){
      //PARAMS.PKG_PARA_UPLD_VAL.PR_SP_FAHMI
      String[] inParam = inputParameter.keySet().toArray(new String[0]);
      SqlParameter[] in = new SqlParameter[inParam.length];
      String[] buff = new String[inParam.length * 2];
      SimpleJdbcCall jdbcCall = new SimpleJdbcCall(paramsDataSourceBean)
                                .withProcedureName(procedureName)
                                .withoutProcedureColumnMetaDataAccess()
                                .useInParameterNames(buff).declareParameters(in);
      String[] path = procedureName.split(".");
      if (path.length &gt;= 2) {
          jdbcCall.withSchemaName(path[0]);
          jdbcCall.withCatalogName(path[1]);
          jdbcCall.withProcedureName(path[2]);
      }
      Map&lt;String,Object&gt; outputParameter = jdbcCall.execute(inputParameter);
  }
  </code></pre>
  
  <p>and this is my stored procedure</p>
  
  <pre><code>PROCEDURE PR_SP_FAHMI (P_T_TABLE_UPLD_EXCEL IN PARAMS.EXCEL)
     is 
    P_LOGID VARCHAR2(255);
  BEGIN
  BEGIN
    INSERT INTO PARAMS.EMPTY
    SELECT 
    C.PARA_OBJT_GROUP            ,
    C.PARA_OBJT_CODE             ,
    C.PARA_PROD_MATRIX_ID        ,
    C.PARA_PROD_CHANNEL_ID       ,
    C.PARA_PROD_SALES_GROUP_ID   ,
    C.PARA_CUST_GROUP            ,
    C.PARA_SLS_THROUGH_ID        ,
    C.ACTIVE                     
    FROM TABLE(P_T_TABLE_UPLD_EXCEL) C;
    EXCEPTION
              WHEN NO_DATA_FOUND THEN
                  NULL;
              WHEN OTHERS THEN
                  RAISE_APPLICATION_ERROR(-20001, 'ERROR-' || SQLERRM);
          END;
  END PR_SP_FAHMI;
  </code></pre>
  
  <p>this is declaration type excel</p>
  
  <pre><code>CREATE OR REPLACE TYPE EXCEL AS TABLE OF PARAMS.T_OBJECT_FROM_EXCEL
  </code></pre>
  
  <p>and this is declaration type T_OBJECT_FROM_EXCEL</p>
  
  <pre><code>CREATE OR REPLACE TYPE "T_OBJECT_FROM_EXCEL" FORCE AS OBJECT (
    para_objt_group            VARCHAR2(3),
    para_objt_code             VARCHAR2(3),
    para_prod_matrix_id        VARCHAR2(5),
    para_prod_channel_id       VARCHAR2(3),
    para_prod_sales_group_id   VARCHAR2(5),
    para_cust_group            VARCHAR2(3),
    para_sls_through_id        VARCHAR2(2),
    active                     NUMBER(1)
  )
  </code></pre>
  
  <p>When i run the code, i have error this</p>
  
  <pre><code>Caused by: java.sql.SQLException: ORA-06550: line 1, column 7:
  PLS-00306: wrong number or types of arguments in call to 'PR_SP_FAHMI'
  ORA-06550: line 1, column 7:
  PL/SQL: Statement ignored
  </code></pre>
  
  <p>I have search in internet to solve this issue by looking similliar error but still can't solve my problem.</p>