Hello All,
I have a situation in which I am having a database with one sequence & trigger per table. The trigger simply sets the Primary key of a table before inserting any record using the sequence created for that table.
Using sequence as generator type doesn't work coz of the triggers i have placed. The sequence gets incremented twice
I want that primary key to be returned while saving the object.
can anyone suggest which generator type can i use..?
Thanks in advance.