To centralize some of your processing, you decide to write PL/SQL library modules that contain procedures that can be called from the triggers or menu items.
You want the message "Credit limit exceeded" to be displayed when the values in the order_total and credit_limit fields in the Orders form meet certain criteria.
Which code do you use?
A.
IF :order_total > 10000
AND :credit_limit < 10000 THEN
MESSAGE(‘Credit limit exceeded’);
END IF;
B.
IF :SYSTEM.cursor_item > 10000
AND :SYSTEM.trigger_item < 10000 THEN
MESSAGE(‘Credit limit exceeded’);
END IF;
C.
IF NAME_IN(‘order_total’) > 10000
AND NAME_IN(‘credit_limit’) < 10000 THEN
MESSAGE(‘Credit limit exceeded’);
END IF;
D.
IF COPY(‘ORDERS.order_total’) > 10000
AND COPY(‘ORDERS.credit_limit’) < 10000 THEN
MESSAGE(‘Credit limit exceeded’);
END IF;
E.
IF :ORDERS.order_total > 10000
AND :ORDERS.credit_limit < 10000 THEN
MESSAGE(‘Credit limit exceeded’);
END IF;