please solve it in SQL ..

Assignment 1 1) Write the code of a stored procedure named proc_cube 2) with one input parameter ip_n_var1 of number data type 3) one output parameter op_n_var2 of number datatype 4) The stored procedure when called, returns the cube value of the input parameter. 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. B) Compile, run, and test and debug the procedure