FUNCTION getPrice(item_Id IN ITEM.itemId%TYPE) RETURN NUMBER IS
	v_listprice item.listprice%TYPE;
	BEGIN
		SELECT listprice, count(listprice) INTO v_listprice
		FROM item
		WHERE itemid = item_id;

		IF(SQL%ROWCOUNT != 1) THEN
			RAISE INVALID_ITEM_ID;
		END IF;

		RETURN v_listprice;

	EXCEPTION
		WHEN INVALID_ITEM_ID THEN
			dbms_output.put_line('Item ID: ' || item_id || ' is invalid.');
			return 0;

	END getPrice;