title: PLS-00306: wrong number or types of arguments in call to a Oracle SP
body: <p>I'm trying to execute a below <code>SP</code> and it throws be the below error:</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE denodo.CLEAR_INDEX
     (   INDEX_NAME1 IN VARCHAR2,
         INDEX_NAME2 IN VARCHAR2,
         IT_WORKED   OUT BOOLEAN ) as
  BEGIN
      IT_WORKED := FALSE;
      EXECUTE IMMEDIATE 'drop index ' || INDEX_NAME1;
      EXECUTE IMMEDIATE 'drop index ' || INDEX_NAME2;
      IT_WORKED := TRUE;
  EXCEPTION
      WHEN OTHERS THEN
         IT_WORKED := FALSE;
  END CLEAR_INDEX;
  </code></pre>
  
  <blockquote>
    <p>CLEAR_INDEX#0 [JDBC ROUTE] [ERROR]  Received exception with message 'ORA-06550: line 1, column 7:
        PLS-00306: wrong number or types of arguments in call to 'CLEAR_INDEX'
        ORA-06550: line 1, column 7:
        PL/SQL: Statement ignored</p>
  </blockquote>
  
  <p>What is going on here? appreciate your help.</p>