In your assignment file that you submit, first, place the code needed to create the procedure. After that, skip a few lines and there include the anonymous block code to call the procedure.

For this problem I want you to include error handling to return a tax amount of 0 if the STATE passed into the procedure is not found in the BB_TAX table. In addition, I'd like you to correct the error that may occur if the user passes in the state in lower case rather than upper case letters.

Assignment 5-2: Using a Procedure with IN Parameters Follow these steps to create a procedure that allows a company employee to add a nevw product to the database. This procedure needs only IN parameters. 1. In SQL Developer, create a procedure named PROD ADD Sp that adds a row for a new product in the BB_PRODUCT table. Keep in mind that the user provides values for the product name, descripton, image filename, price, and active status. Address the input values or parameters in the same order as in the preceding sentence 2, call the procedure with these parameter values: Roasted Blend. well-balanced mix of roasted beans, a medium body''roasted.jpg'.9.50.1) 3. Check whether the update was successful by querying the BB_PRODUCT table