Exercise

Putting it all together

Now you're ready to put together what you learned in Chapter 4 with the stacked diagnostics functions from the previous exercises. I've already created the patients table from the prior exercise as well as the debug_statement function. You'll begin by debugging another exception type. Then you'll combine a DO function, SQL statements stored in a variable, and trigger debugging on an exception.

Instructions 1/2

undefined XP
    1
    2

Question

What type of error does INSERT INTO PATIENTS (fasting) VALUES ('no') give when wrapped in the debug_statement function?

Note: you need to run both the debug statement and the error select statement together in the same console window. Make sure to use double single quotes around no to properly escape the statement and use semicolons at the end to separate the two statements.

Possible answers