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

with pl/Sql code with pl/Sql code Assignment 2 1) Create a procedure called "divide_by_zero". 2)

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!