Executing a stored procedure that throws an error

You need to insert a new product using the stored procedure you created in the previous exercise:

CREATE PROCEDURE insert_product
  @product_name VARCHAR(50),
  @stock INT,
  @price DECIMAL

AS

BEGIN TRY
    INSERT INTO products (product_name, stock, price)
        VALUES (@product_name, @stock, @price);
END TRY
BEGIN CATCH    
    INSERT INTO errors VALUES ('Error inserting a product');  
    THROW;  
END CATCH

You want to register that you received 3 Super bike bikes with a price of $499.99. You need to catch the possible errors generated in the execution of the stored procedure, showing the original error message.

How do you prepare the script?

Execute the stored procedure called insert_product.
Set the appropriate values for the parameters of the stored procedure.
Surround the error handling with a CATCH block.
Select the error message.

Take Hint (-30 XP)

Exercise

Executing a stored procedure that throws an error

Instructions