CREATE TABLE DIMDATE (
    DATEKEY           INT PRIMARY KEY,
    FULLDATE          TIMESTAMP(2) NOT NULL,
    DAYOFMONTH        INT NULL,
    DAYSHORTNAME      VARCHAR(4) NULL,
    DAYNAME           VARCHAR(9) NULL,
    WEEKOFMONTH       INT NULL,
    WEEKOFQUARTER     INT NULL,
    MONTHNAME         VARCHAR(9) NULL,
    QUARTER           CHAR(1) NULL,
    FULLYEAR          CHAR(4) NULL,
    MMYYYY            CHAR(6) NULL,
    FIRSTDAYOFMONTH   DATE NULL,
    LASTDAYOFMONTH    DATE NULL,
    FIRSTDAYOFQUARTER DATE NULL,
    LASTDAYOFQUARTER  DATE NULL,
    FIRSTDAYOFYEAR    DATE NULL,
    LASTDAYOFYEAR     DATE NULL,
    ISWEEKDAY         CHAR(1) NOT NULL,
    ISHOLIDAY         CHAR(1) NOT NULL
);

/* Setting the format for timestamp and date */
ALTER SESSION SET NLS_TIMESTAMP_FORMAT='YYYY-MM-DD HH:MI:SS';

ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD';

INSERT INTO DIMDATE VALUES (
    301,
    TO_TIMESTAMP('2024-03-01 00:00:00'),
    1,
    'Fri',
    'Friday',
    1,
    9,
    'March',
    '1',
    '2024',
    '032024',
    TO_DATE('2024-03-01'),
    TO_DATE('2024-03-31'),
    TO_DATE('2024-01-01'),
    TO_DATE('2024-03-31'),
    TO_DATE('2024-01-01'),
    TO_DATE('2024-12-31'),
    'Y',
    'N'
);

I’m trying to insert the values but I could not identify the error. The specific error message for this one is ORA-01843: An invalid month was specified. Error at Line: 8 Column: 0. However, this snippet started at line 413. Where did I went wrong?

I did not try anything yet since I’m not familiar with Oracle SQL, however I expect that I could insert values them without errors