If the value for the listprice column is a negative number

Assignment Help PL-SQL Programming

Reference no: EM13166176

Write a script that creates and calls a stored procedure named spInsertProduct that inserts a row into the Products table. This stored procedure should accept five parameters. One parameter for each of these columns: CategoryID, ProductCode, ProductName, ListPrice, and DiscountPercent.

This stored procedure should set the Description column to an empty string, and it should set the DateAdded column to the current date.

If the value for the ListPrice 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 DiscountPercent column is a negative number.

Code at least two EXEC statements that test this procedure.

Reference no: EM13166176

Questions Cloud

Calculate the vapor pressure of water inside pressure cooker : the temperature inside a pressure cooker is 111°C. Calculate the vapor pressure of water inside the pressure cooker.

Review of the audit process and timeline : Discussion of business objectives, risks and key processes and review of the audit process and timeline

Java program that implements an algorithm known as a bubble : writing a simple Java program that implements an algorithm known as a Bubble Sort. A Bubble Sort is a simple sorting algorithm that takes an unsorted array of elements and sorts them into ascending order.

Calculate the number of milliliters that must be added : in the titration of 25.00ml of 0.100M CH3COOH, calculate the number of milliliters of 0.200 M NaOH that must be added to reach a pH of a)3.85, b) 5.25,

If the value for the listprice column is a negative number : If the value for the ListPrice 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 DiscountPer..

State ammonia and hydrogen chloride gases react : Ammonia and hydrogen chloride gases react to form solid ammonium chloride. A 10.0 L reaction flask contains ammonia at 0.450 atm and 22°C, and 164 mL of hydrogen chloride gas at 7.50 atm and 271 K is introduced

How many grams of co are required to react : Iron (III) oxide reacts with carbon monoxide to form elemental iron and carbon dioxide. How many grams of CO are required to react with 2.78 grams of Fe2O3?

The chief information officer (cio) has outlined : The Chief Information Officer (CIO) has outlined the key requirements for a new network for UMUC. He has explained to the executive board that a new network would have the following characteristics.

Create a method that would search through an arraylist : What is the best way of the following ways (For each, Iterator, While with index) that you would use to create a method that would search through an ArrayList of files for a certain file and then delete it, and why?

User Account

All Pages