If you do "nothing special", your users will see an error. By default you will get an "ORA-00001 unique constraint (constraint name) violated" message, though you can use the TOracleSession.MessageTable to translate this to something more meaningful.
If you are using an event like TOracleDataSet.OnPostError, you may be able to hide the error.
------------------
Marco Kalter
Allround Automations