All -
We have this same "internal error" problem. It's actually a bug in Oracle9i that has issues around using cursor%rowtype variables. Oracle said it will not be fixed until the next patch... in February. The work around is to define your cursor in the package specification instead of somewhere in the package body. Yes, this is not the best coding technique, but it allows us to upgrade to 9i now!
- Tim