Which block of code displays the error message “Incorrect price value”?
Which block of code displays the error message “Incorrect price value”?
The code block that displays the error message 'Incorrect price value' is the one that properly raises and handles the exception for this specific error. Block 'B' includes the necessary exception handling to output the specified error message, which is why it is the correct choice.
B is correct But C gives the same result
No, C does not give the same result. Not only it (re)named ORA-02001: user SYS is not permitted to create indexes with freelist groups, but also is out of scope for outer exception handler.
Tested - B. Error means successful message from the exception
C is wrong because negative error code should be in the range -20000 .. -20999
B because exception raised in declarative section must be handle in a superior bloc
tested B