5. Write a script that creates and calls a stored procedure named update_product_discount that updates the...

Transcribed Image Text:

5. Write a script that creates and calls a stored procedure named update_product_discount that updates the discount_percent column in the Products table. This procedure should have one parameter for the product ID and another for the discount percent. If the value for the discount_percent column is a negative number, the stored procedure should raise an error that the value for this column must be a positive number. Code at least two CALL statements that test this procedure. 5. Write a script that creates and calls a stored procedure named update_product_discount that updates the discount_percent column in the Products table. This procedure should have one parameter for the product ID and another for the discount percent. If the value for the discount_percent column is a negative number, the stored procedure should raise an error that the value for this column must be a positive number. Code at least two CALL statements that test this procedure.