Exit Handler in HANA XSA

[former_member597564]

I have written one stored procedure in hana xsa where i have written INSERT statement to insert data into Tables.

Suppose i am trying to insert duplicate entry into table then it should throw an error

other wise it should throw a SUCCESS message.

How to do this in HANA Procedures?

[pfefferf · Accepted solution]

In case a unique constraint is violated by your insert statement, the database raises an error (code 301 as you can see here). So by registering an exit handler (as described here) you can react on that error code and do whatever you wanna do.