What will be in 9i that will alleviate this problem?

Can you say more about encapsulating the table in a Stored Procedure like Object-Oriented approach? Which table? I'm not clear what you are suggesting and how it would resolve the issue?

thanks