CheckPrice

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   PRODUCTS   >   CheckPrice

Function body CheckPrice(price NUMBER) return CheckPrice, Package PRODUCTS

Name	Datatype	Precision	Description
price	NUMBER		NUMBER, parameter of PRODUCTS.CheckPrice

function CheckPrice(price in NUMBER) return boolean
	is
		past_due EXCEPTION;  -- this declaration prevails
	begin 
		IF price < 100 THEN
			RAISE past_due;  -- this is not handled
		END IF;
		return(true);
	end CheckPrice

Name	Types	Description
<DEFAULT SCHEMA>.PRODUCTS.CheckPrice	Function	Function interface CheckPrice(price NUMBER) return BOOLEAN, Package PRODUCTS
BOOLEAN	PL/SQL System type	PL/SQL System Object
Exception	PL/SQL System type	PL/SQL System Object
NUMBER	PL/SQL System type	PL/SQL System Object

Name	Types	Description
<DEFAULT SCHEMA>.CHECKPRODUCT	Trigger	Simple Trigger of AFTER "update ON Product"