I need to create all the business rules of a system within the database and allow other applications for the purpose of being just a graphical user interface to freely use all the functions available in the database through stored procedures.
Among them, I need to create a procedure that, given starting coordinates and destination coordinates, it accesses GOOGLEMAPS and RETURNS the distance in ROUTE (not in a straight line).
Is it possible?