Chapter 4: Error Handling
In This Chapter
Identifying error conditions
Discovering SQLSTATE
Dealing with whatever comes your way
Using the WHENEVER clause
Checking the diagnostics areas
Seeing an example of a constraint violation
Putting more constraints on an existing table
Interpreting SQLSTATE information
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 ...