Do not treat it as an unexpected error

this is a predictable business condition (e.g., a duplicate transaction ID). 2. **Check SQLERRM** to identify which index caused the violation (SQLERRM contains the index name). 3. **Take appropriate business action**: generate a new unique key and retry, reject the transaction with a user-friendly