LAST_INSERT_ID ia a AFRTER INSERT trigger
I'm trying to duplicate data inserted by one application into another aplication's table. Both use auto-increment id's as the primary key.
The operation is performed by a stored procedure called from the after insert trigger on the original table.
Using last_insert_id() however keeps returning '0'.
Can someone please confirm that this is the way it works.
If not, does anyone know how to solve the problem?
I'm using triggers on the original tables, because i have no way to modify the application. All i can act on is the data being inserted.
Subject
Views
Written By
Posted
LAST_INSERT_ID ia a AFRTER INSERT trigger
1764
October 01, 2018 03:48PM
839
October 01, 2018 05:44PM
807
October 04, 2018 02:19AM
763
October 04, 2018 08:27AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.