distance between two points
Hi, I have some problems with detecting distance by lenght of LineString
AsBinary() is working well but when I want to create LineStringFromWKB I recieve only NULL
it is my sql:
SELECT ROUND( GLength( LineStringFromWKB( LineString( AsBinary( a.g ) , AsBinary( b.g ) ) ) ) ) AS dis
FROM cities a, cities b
WHERE a.name = 'Zakopane'
AND b.name = 'Warszawa'
-------
dis
NULL
PLEASE HELP
Subject
Views
Written By
Posted
distance between two points
4898
April 10, 2010 03:58PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.