Unable to Set Column Stats (Invalid or inconsistent input values)

 Hi Folks

I am trying to use Note 1276174.1 (An example of SET_COLUMN_STATS to set LOW_VALUE and HIGH_VALUE of a column manually)

When I run my tests according to the examples it runs fine

but when i change the table and column it craps out on me and i cannot figure out why

Any assistance would be appreciated as I am stumped

Thanks

Jim

==============

works

==============

DECLARE

   srec               DBMS_STATS.STATREC;

   v_distcnt          NUMBER;

   v_density          NUMBER;

   v_nullcnt          NUMBER;

   v_avgclen          NUMBER;

   numvals            DBMS_STATS.NUMARRAY;

   charvals           DBMS_STATS.CHARARRAY;

   datevals           DBMS_STATS.DATEARRAY;

BEGIN

   -- Date Type