Hi,
I have installed Oracle Express 11g on Windows Server 2008:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
I aim to learn about ST_GEOMETRY features.
I tried a few very basic queries, but I'm puzzled about the results I'm getting
Here are two queries I tried:
SELECT TREAT(ST_GEOMETRY.FROM_WKT('POINT(10 10)') AS ST_POINT).GET_WKT() AS PT FROM dual;
SELECT TREAT(ST_GEOMETRY.FROM_WKT('MULTIPOINT((10.0 10.0),(15.0 10.0)',0) AS ST_MultiPoint).Get_WKT() AS geom from dual;
The two screenshots below show that either I get no WKT printed (ST_POINT) or I'm haunted with the "ORA-30625: method dispatch on NULL SELF argument is disallowed" error (ST_MULTIPOINT).
I also tried a few variations of basic queries using ST_GEOMETRY, its subtypes and GET/FROM_WKT functions, which are supposed to be correct (found on the web, in Oracle Spatial books by APRESS/Packt and here on the forum) but in most cases I'm getting the ORA-30625 error.
I understand the output is CLOB, but setting SQLPlus with, e.g. SET long 2000 does not make any difference.
Please, could anyone help me to understand what is going on?
Message was edited by: mloskot Update about SET long