Question

Oracle 11g PL/SQL Programming Sometimes Brewbean’s customers mistakenly leave an item out of a basket that’s already been checked out, so they create a new basket containing the missing items. However, they request that the baskets be combined so that they aren’t charged extra shipping. An application page has been developed that enables employees to change the basket ID of items in the BB_BASKETITEM table to another existing basket’s ID to combine the baskets. A block has been constructed to support this page (see the assignment04−07.sql file in the Chapter04 folder). However, an exception handler needs to be added to trap the situation of an invalid basket ID being entered for the original basket. In this case, the UPDATE affects no rows but doesn’t raise an Oracle error. The handler should display the message “Invalid original basket ID” onscreen. Use an initialized variable named lv_old_num with a value of 30 and another named lv_new_num with a value of 4 to provide values to the block. First, verify that no item rows with the basket ID 30 exist in the BB_BASKETITEM table.

BEGIN
UPDATE bb_basketitem
SET idBasket = ??
WHERE idBasket = ??;
END;

Answer 1

e veut hamaless in the crme . befele ol rffet CGREATE ALTER, DRop et on B BASKETITEM fel each low geaiu 休1 end if end