Review My 'Get_Total' Function - PL/SQL

This code will be applied to a hotel database. II got a short pl/sql code that calculates the total price a customer has to pay.

Total price is calculated based on how many nights the client has booked the room for.

v_nights represents number of nights the client's has booked.

Don't worry about exception, i'm more concerned about the body.

Regards,
F-J-K

CREATE OR REPLACE FUNCTION get_total(customer_num IN customer.CustomerID%TYPE)
RETURN NUMBER IS
	   v_price	   MotelRoom.PRICE%TYPE;
	   v_nights	   INTEGER;
	   total_price NUMBER;
BEGIN
	   SELECT mr.price, TO_DATE(checkout, 'dd') - TO_DATE(checkin, 'dd') INTO v_price, v_nights
	   FROM MotelRoom mr JOIN BookedRoom b
	   ON	mr.roomID = b.roomID
	   WHERE b.customerID = customer_num;

	   total_price := v_price * v_nights;
	   
	   RETURN total_price;
	   
EXCEPTION
	   WHEN OTHERS THEN
	   		RAISE_APPLICATION_ERROR(-20001, 'There was an error when get_total function was run. ' || SQLCODE || ', ' || SUBSTR(SQLERRM, 1, 200)); 	  
END;
/

Select allOpen in new window