get min_value, max_value from Table_Name/Column_Name in a table

[chombria]

I try to get Minimum and Maximum Values for columns/tables with names are in a table. Table name is CAMPOS_DATE and TABLE_NAME, COLUMN_NAME have table and column names.
I try to get MIN and MAX values for columns and I have created next procesure

CREATE OR REPLACE PROCEDURE "NA_PRC_MIN_MAX_DATES_CHM" IS
 
    -- ------------------------------------------------------------------ --
    -- Cursores                                                           --
    -- ------------------------------------------------------------------ --
 
 
    CURSOR cColumnas IS
    SELECT 
        TABLE_NAME,
        COLUMN_NAME
    FROM CAMPOS_DATE;
    -- ------------------------------------------------------------------ --
    -- Variables                                                          --
    -- ------------------------------------------------------------------ --
    vdMinValue      DATE;
    vdMaxValue      DATE;
 
BEGIN
 
  FOR rcCol IN cColumnas LOOP
 
    vdMinValue := NULL;
    vdMaxValue := NULL;
    SELECT MIN(rcCol.COLUMN_NAME), max(rcCol.COLUM_NAME)
    INTO vdMinValue, vdMaxValue
    FROM rcCol.TABLE_NAME;
 
    UPDATE CAMPOS_DATE
    SET MIN_VALUE = vdMinValue,
        MAX_VALUE = vdMaxValue
    WHERE TABLE_NAME = rcCol.TABLE_NAME
    AND COLUMN_NAME = rcCol.COLUMN_NAME;
 
    COMMIT;
 
  END LOOP;
 
EXCEPTION
    WHEN OTHERS THEN
      ROLLBACK;
END;
/
 

It doesn´t work. What am I doing wrong?

Thanks in advance