Using %TYPE

This sounds strange.

I encountered complilaton error for a pacakge in 8.1.7

I suspect that %TYPE may have problem with the the last column of a table, and

this column is created through the 'alter table add ...' syntax. I added a dummy

column to the table, then re-complile, the package became valid. Then I drop the

dummy column, and recompile all invalid packages, the package and its body now becomes valid.