04 September 2010
Players cry "No choices right!" for 3 September quiz(1370)
The 3 September quiz regarding use of the RAISE; statement includes this paragraph: Each of the choices below contain code to create a procedure named proc2 (and in some cases, another procedure named show_error). After executing the code in each choice, I then want to run the following block and see an unhandled VALUE_ERROR exception ("ORA-06502: PL/SQL: numeric or value error"). Several players wrote to say that none of the choices could be correct because all of them could only display at most the error code, but not the error message, since I called SQLCODE and not SQLERRM. That is true, but what I stated was that I want to "see an unhandled VALUE_ERROR exception." I then included the full message text in parentheses to be clear about how the VALUE_ERROR exception (defined in the STANDARD package) would appear as an unhandled Oracle error. I did not ask "What text will be displayed on the screen?" So I believe that the quiz was scored correctly and no changes will be made. Your thoughts?