Question: with pl/Sql code Assignment 2 1) Create a procedure called divide_by_zero. 2) Declare two variables named x and y of type number. Assign x the
Assignment 2 1) Create a procedure called "divide_by_zero". 2) Declare two variables named x and y of type number. Assign x the value of one and y the value of zero. 3) In the body of the procedure assign x the value of x divided by y. (This will result in a divide by zero error - expected for this exercise). 4) Add a line that outputs We will not get here that demonstrates that the divide by zero exception raised in the previous line will bypass the following lines. 5) Add an exception section to handle the divide by zero error. 6) Add a line to the exception section that outputs "USER MESSAGE: Error in: program unit name line line number". 7) Add a line that prints out the call stack at the point the error occurred. 8) Compile, run, and test and debug the procedure
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
