ORA-06512: at "SYS.DBMS_STATS", line 13437

ORA-00909: invalid number of arguments
ORA-06512: at "SYS.DBMS_STATS", line 13437
ORA-06512: at "SYS.DBMS_STATS", line 13457
ORA-06512: at line 2


The error appears when try to execute ( the size should be defined ) :

BEGIN
  DBMS_STATS.GATHER_TABLE_STATS('X',
                                'XXX',
                                NULL,
                                DBMS_STATS.AUTO_SAMPLE_SIZE,
                                FALSE,
                                'FOR ALL INDEXED COLUMNS SIZE ',
                                DBMS_STATS.DEFAULT_DEGREE,
                                'ALL',
                                TRUE,
                                NULL,
                                NULL,
                                NULL,
                                FALSE);
END;

Solution(with bold):

BEGIN
  DBMS_STATS.GATHER_TABLE_STATS('X',
                                'XXX',
                                NULL,
                                DBMS_STATS.AUTO_SAMPLE_SIZE,
                                FALSE,
                                'FOR ALL INDEXED COLUMNS SIZE 1',
                                DBMS_STATS.DEFAULT_DEGREE,
                                'ALL',
                                TRUE,
                                NULL,
                                NULL,
                                NULL,
                                FALSE);
END;