Storing complete table rows in a single field

I need to be able to store complete rows retrieved from various tables (SELECT * ...) as a single field in another table. Basically I need to keep a record of every change made to various tables, like an audit trail, but I need the entire record not just the changes. I can do this in SQL Server but now I need to port it to Oracle. I get the feeling that Object Tables and %ROWTYPE comes into it somewhere but I can't quite get it all to work together.

Any ideas?

Ken Received on Thu Jan 22 2004 - 11:37:12 CST