(Solved) : Write Script Creates Calls Stored Procedure Named Insertproducts Inserts Row Products Tabl Q37178208 . . .
Write a script that creates and calls a stored procedure named insert_products that inserts a row into the Products table. This stored procedure should accept five parameters, one for each of these columns: category id. product_code, product name, list _price, and discount percent. This stored procedure should set the description column to an empty string, and it should set the date added column to the current dat If the value for the list price column is a negative number, the stored procedure should raise an error that indicates that this column doesn’t accept negative numbers. Similarly. the procedure should raise an error if the value for the discount percent column is a negative number. Code at least two CALL statements that test this procedure Show transcribed image text Write a script that creates and calls a stored procedure named insert_products that inserts a row into the Products table. This stored procedure should accept five parameters, one for each of these columns: category id. product_code, product name, list _price, and discount percent. This stored procedure should set the description column to an empty string, and it should set the date added column to the current dat If the value for the list price column is a negative number, the stored procedure should raise an error that indicates that this column doesn’t accept negative numbers. Similarly. the procedure should raise an error if the value for the discount percent column is a negative number. Code at least two CALL statements that test this procedure
Expert Answer
Answer to Write a script that creates and calls a stored procedure named insert_products that inserts a row into the Products tabl…
OR