title: Procedure Error: ORA-24344: success with compilation error
body: <p>The procedure takes two dates and find the reports that issued during this duration, and update total salary, and print them.</p>
  <pre><code>CREATE OR REPLACE PROCEDURE Salary_Update(p_Date1 DATE, p_Date2 DATE) AS 
  CURSOR MYCR IS 
  SELECT ReportID, TotalSale, Rate, TotalSalary, ReportDate
  FROM WEEKLY_REPORT
  WHERE ReportDate BETWEEN TO_DATE(p_Date1, 'DD-MM-YYYY') AND TO_DATE(p_Date2, 'DD-MM-YYYY'); 
  BEGIN
  FOR MYPOINTER IN MYCR LOOP
  UPDATE WEEKLY_REPORT SET TotalSalary = ((TotalSale/100)*Rate);
  DBMS_OUTPUT.PUT_LINE('The total salary for report ' || MYPOINTER.REPORTID || '  updated to ' || MYPOINTER.TotalSalary || 'dollars, which is ' || MYPOINTER.Rate || '% of the total sale of ' || MYPOINTER.TotalSale || 'dollars.');
  WHERE ReportID = MYPOINTER.ReportID;
  END LOOP;
  END Salary_Update;
  /
  </code></pre>
  <p>the execution</p>
  <pre><code>BEGIN Salary_Update('02-04-2020','05-04-2020');
  END;
  BEGIN 
  Salary_Update(to_date('02-04-2020','dd-mm-yyyy'), to_date('05-04-2020','dd-mm-yyyy'));
  END;
  </code></pre>
  <p>both don't work.</p>