Anton, you are my hero!

For those who have 10.1.0.3.0, and invalidate procedure is missing
from dbms_utility, here's how I did it:

PRAGMA AUTONOMOUS_TRANSACTION;
..
..
..
dbms_job.submit(t_id,'EXECUTE IMMEDIATE ''ALTER TYPE PivotImpl COMPILE
BODY'';');

Anton, you are my hero!

For those who have 10.1.0.3.0, and invalidate procedure is missing
from dbms_utility, here's how I did it:

PRAGMA AUTONOMOUS_TRANSACTION;
..
..
..
dbms_job.submit(t_id,'EXECUTE IMMEDIATE ''ALTER TYPE PivotImpl COMPILE
BODY'';');

Anton, you are my hero!

For those who have 10.1.0.3.0, and invalidate procedure is missing
from dbms_utility, here's how I did it:

PRAGMA AUTONOMOUS_TRANSACTION;
..
..
..
dbms_job.submit(t_id,'EXECUTE IMMEDIATE ''ALTER TYPE PivotImpl COMPILE
BODY'';');

Anton, you are my hero!

For those who have 10.1.0.3.0, and invalidate procedure is missing
from dbms_utility, here's how I did it:

PRAGMA AUTONOMOUS_TRANSACTION;
..
..
..
dbms_job.submit(t_id,'EXECUTE IMMEDIATE ''ALTER TYPE PivotImpl COMPILE
BODY'';');

Anton, you are my hero!

For those who have 10.1.0.3.0, and invalidate procedure is missing
from dbms_utility, here's how I did it:

PRAGMA AUTONOMOUS_TRANSACTION;
..
..
..
dbms_job.submit(t_id,'EXECUTE IMMEDIATE ''ALTER TYPE PivotImpl COMPILE
BODY'';');