title: PLS-00382: expression is of wrong type for procedure
body: <p>I am making a procedure but I am getting a error(PLS-00382: expression is of wrong type) while executing statement in the line(EXECUTE IMMEDIATE V_QUERY)`:</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE SUMMARY(V_NDAY IN NUMBER ) IS
  V_QUERY NVARCHAR2 (5000);
  
  BEGIN
    V_QUERY := 'DROP TABLE temp_summary';
    EXECUTE IMMEDIATE V_QUERY;
  END SUMMARY;
  </code></pre>