Chapter 4: Error Handling

In This Chapter

arrow Identifying error conditions

arrow Discovering SQLSTATE

arrow Dealing with whatever comes your way

arrow Using the WHENEVER clause

arrow Checking the diagnostics areas

arrow Seeing an example of a constraint violation

arrow Putting more constraints on an existing table

arrow Interpreting SQLSTATE information

arrow Handling exceptions

Wouldn’t it be great if every application you wrote worked perfectly every time? Yeah, and it would also be really cool to win $210 million in the Powerball lottery. Unfortunately, both possibilities are equally unlikely to happen. Error conditions of one sort ...

Get SQL All-in-One For Dummies®, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.