Handling exceptions with undefined errors

Assignment Help PL-SQL Programming

Reference no: EM131370707

Assignment: Handling Exceptions with Undefined Errors

Brewbean's wants to add a check constraint on the QUANTITY column of the BB_BASKETITEM table. If a shopper enters a quantity value greater than 20 for an item, Brewbean's wants to display the message "Check Quantity" onscreen.

Using a text editor, open the assignment04-06.txt file in the Chapter04 folder.

The first statement, ALTER TABLE, must be executed to add the check constraint. The next item is a PL/SQL block containing an INSERT action that tests this check constraint.

Add code to this block to trap the check constraint violation and display the message.

Reference no: EM131370707

Questions Cloud

What is the empirical formula of the compound : What is the empirical formula of the compound - Talc (used in talcum powder) has mass- composition 19.2% Mg, 29.6% Si, 42.2% O, and 9.0% H.

The bigger the size the more valuable the lobster per pound : Lobsters vary in sizes. The bigger the size, the more valuable the lobster per pound. Lobster merchants will sell entire boatloads for a certain price. The boatload has a mixture of sizes. Suppose the distribution is as follows:

Biblical basis of life significance : Evaluate and analyze the arguments in the presentation "Biblical Basis of Life's Significance," found in the Reading & Study folder of Module/Week 1. Construct a single sentence of 40 words or less. Include within it 4 carefully crafted and concis..

Why does the video most resonate with you : Why does the video most resonate with you? How does this clip illustrate charismatic, transformational, and/or servant leadership? What can you learn from this individual's approach to leadership, as depicted in the video clip, as you continue to ..

Handling exceptions with undefined errors : The first statement, ALTER TABLE, must be executed to add the check constraint. The next item is a PL/SQL block containing an INSERT action that tests this check constraint.

Working at a health fair in a local mall : What actions should you take? What questions can you ask him? What signs and symptoms should you be looking for?

Calculate expected income without any insurance coverage : Joe is currently unemployed and without health insurance coverage. He derives utility (U) from his interest income on his savings (Y) according to the following function: U = 5(Y1/2). Calculate Joe’s expected utility level without any health insuranc..

Write a summary for your paper by summarizing malcom xs : This is the final contribution to the course research paper, and it allows you to prepare concluding thoughts about Malcolm X leadership style as well as the impact of his or her leadership, particularly as it relates to leading change and/or inno..

Municipal application of a bacterial or archaeal activity : Describe one industrial or municipal application of a bacterial or archaeal activity. In your description, specify the microorganisms doing the work (i.e., indicate the genus and species name(s) where possible), and describe the main carbon source..

User Account

All Pages