Re: Getting currval from a sequence with out incrementing nextval

Well, as I said - use an exception handler on the trigger. It can call a procedure which can can have going over a loop, say 100 times before raising an error.

But the proverbial lead pipe does wonders, here.

Oh - and have them test without cached sequences (nocache noorder nocycle) - so you can query dba_sequences ;)

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...