Hello guys. I am new to Oracle Spatial. and this problem really killing my time.. I need help badly
1. The user will give me coordinates(x,y) and using that coordinate i should find the nearest road(line segment) - I already did this and working well.
2. Next is to. adjust the given coordinates(from the user) by offsetting it to the nearest road by .6 meters - This is what killing me right now.
3. And return the adjusted coordinate.