title: Error: PL/SQL: Compilation unit analysis terminated?
body: <p>Keep Getting the same error on both codes!!</p>
  
  <pre><code>DROP TABLE Date_Dimension CASCADE CONSTRAINTS ;
  
  CREATE TABLE Date_Dimension
    (
      date_key             NUMBER NOT NULL ,
      full_date            DATE ,
      day_of_week          NUMBER ,
      day_num_in_month     NUMBER ,
      day_num_overall      NUMBER ,
      day_name             VARCHAR2 (9) ,
      day_abbrev           VARCHAR2 (3) ,
      week_num_in_year     NUMBER ,
      week_num_overall     NUMBER ,
      week_begin_date      DATE ,
      MONTH                NUMBER ,
      month_number_overall NUMBER ,
      month_name           VARCHAR2 (9) ,
      month_abbrev         VARCHAR2 (3) ,
      quarter              NUMBER ,
      YEAR                 VARCHAR2 (20) ,
      century              NUMBER
    ) ;
  ALTER TABLE Date_Dimension ADD CONSTRAINT Date_Dimension_PK PRIMARY KEY ( date_key ) ;
  
  Create or replace PROCEDURE sp_DATE_DIMENSION(v_STARTDATE IN INT, v_END_YEAR IN INT) IS
  
  v_STARTDATE DATE;
  v_ENDDATE DATE;
  
  v_STARTDATE Date := to_date('2005/01/01' || v_START_YEAR, 'YYYY/MM/DD');
  v_ENDDATE Date := to_date('2020/12/31' || v_END_YEAR,'YYYY/MM/DD');
  
  BEGIN
  
  INSERT INTO
  
    Date_Dimension 
    (date_key,full_date, day_of_week, day_num_in_month, day_num_overall, day_name, day_abbrev, week_num_in_year, week_num_overall, month, month_name, month_abbrev, quarter, year, century)
  
  VALUES
    (
   '1',TO_DATE(v_STARTDATE, 'yyyy/mm/dd'), TO_NUMBER(v_STARTDATE, 'D'), TO_NUMBER(v_STARTDATE, 'DD'), TO_NUMBER(v_STARTDATE, 'DDD'), TO_CHAR(v_STARTDATE, 'DAY'), TO_CHAR(v_STARDATE, 'DY'), TO_NUMBER(v_STARTDATE, 'IW'), TO_NUMBER(v_STARTDATE, 'WW'), TO_NUMBER(v_STARTDATE, 'MM'), TO_CHAR (v_STARTDATE, 'MONTH'), TO_CHAR (v_STARTDATE, 'MON'), TO_NUMBER (v_STARTDATE, 'Q'), TO_CHAR (v_STARTDATE, 'YEAR'), TO_NUMBER (v_STARTDATE, 'CC') 
    )
  ;
  
  IF v_STARTDATE &gt; v_ENDDATE THEN
  
    DBMS_OUTPUT.PUT_LINE ('ERROR IN CODE REGARDING DATES CHOSEN');
  
  ELSE
  
      WHILE v_STARTDATE &lt;= V_ENDDATE LOOP 
          DBMS_OUTPUT.PUT_LINE ('Date : '||to_char(v_StartDate,'YYYY / MM / DD'));
  
          v_STARTDATE := v_STARTDATE + 1;
  
      END LOOP;
  END IF;
  END;
  </code></pre>