I <3 Oracle

Lies!!

For my own future reference, to get the last inserted ID (being created by the trigger from a sequence because auto increment is non existant) simply do this:

SELECT schema.sequence_name.currval as the_id FROM dual

Yep.. simple eh? I couldn't find that anyplace online, so I'll try and include some descriptive keywords I searched for like last inserted ID, auto_increment, last_number, OK I think that's enough.

Tschüss!