Categories
Mastering Development

Decrement oracle sequence when an exception occured

I try to insert a new record in my database using pl/sql, so first of all i generate a new sequence like so : select my_seq.nextval into seqId from dual ; And then i try to insert a new record using the generated seqId like this : insert into myTable (id) values seqId ; But […]