Skip to Content
0
Former Member
May 21, 2013 at 07:59 PM

Is it possible to catch SQL exceptions?

104 Views

Hi all,

I would like to catch SQL exceptions 301 - unique constraint violated when inserting data into a table. I've got a largish table to which I'm adding data from CSV files from time to time. Some of the new rows are duplicates of already present ones, this cannot be helped. I've tried to declare a trigger for the INSERT statement, however this does not seem to help. That is, a TRIGGER AFTER INSERT does not prevent the exception to be raised and a TRIGGER BEFORE cannot, at least so says the docs, access the table, so it cannot check if the insert will produce a 301. So is this possible in Hana at all?

Cheers,

-- Micha