Question
Question 6. Perform Exception Handling with User-Defined Errors (3 Marks) In order to increase the sales of ID PRODUCT number 8 which is Brazil the
Question 6. Perform Exception Handling with User-Defined Errors (3 Marks)
In order to increase the sales of ID PRODUCT number 8 which is Brazil the management requested that to each order of Brazil coffee should be more than 2 quantity.
Create an exception that will be raised if any entered order contains IDPRODUCT 8 with less than 2 quantity and display the message Minimum quantity order of Brazilian Coffee is 2. Test your exception with insert statement into BB_BASKETITEM table.
Refer to bb_product table in order to find related IDPRODUCT column information
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started