Task 3: Create(Enter) new product by using a Procedure with IN Parameters Follow these steps to create a procedure that allows a company employee to add a new product to the database. This procedure needs only IN parameters. In SQL Developer, create a procedure namedPROD_ADD_SPthat adds a row for a new product in the BB_PRODUCT table. Keep in mind that the user provides values for the product name, description, image filename (use same template for file name as ‘roasted.jpg’ or ‘double-roasted.jpg’ ) , price, and active status. Address the input values or parameters in the same order as in the preceding sentence. Call the procedure with these parameter values:('Roasted Blend', 'Well-balanced mix of roasted beans, a medium body', 'roasted.jpg',9.50,1). Check whether the update was successful by querying the BB_PRODUCT table. -This will be a page where you allow new product information to be entered into Edit box by end user and then there will be INSERT or ADD Product button to save them by calling this Stored Procedure. -And Once your Product add tasks is completed GUI will bring the full product list with newly added one at the below part of your screen -Also there should be only one Product Search capability in the same Page. On the same page,(maybe in different part of your page) open a edit box and accept product name and search based on that product name and bring to list on screen.
please use sql to answer the following question and erd and code from the last test (tesk 2) have been provide and it connect to task 3 as well
Task 3: Create(Enter) new product by using a Procedure with IN Parameters
Follow these steps to create a procedure that allows a company employee to add a new
product to the
- In SQL Developer, create a procedure namedPROD_ADD_SPthat adds a row for a new
product in the BB_PRODUCT table. Keep in mind that the user provides values for the
product name, description, image filename (use same template for file name as ‘roasted.jpg’ or ‘double-roasted.jpg’ ) , price, and active status. Address the input values or parameters in the same order as in the preceding sentence.
- Call the procedure with these parameter values:('Roasted Blend', 'Well-balanced
mix of roasted beans, a medium body', 'roasted.jpg',9.50,1).
- Check whether the update was successful by querying the BB_PRODUCT table.
-This will be a page where you allow new product information to be entered into Edit box by end user and then there will be INSERT or ADD Product button to save them by calling this Stored Procedure.
-And Once your Product add tasks is completed GUI will bring the full product list with newly added one at the below part of your screen
-Also there should be only one Product Search capability in the same Page. On the same page,(maybe in different part of your page) open a edit box and accept product name and search based on that product name and bring to list on screen.
Step by step
Solved in 3 steps with 2 images
