I would like to avoid being locked into Oracle technology

It's safe to say you can forget about that, unless you don't use Oracle:)

More seriously: avoid using any PLSQL extensions, instead only use plain/standard SQL. Don't use stored procedures, they're in now way standardized.

Keeping track of history can be notoriously difficult. Give it lots of thought before you implement something!