I'm new to this, so I assume I'm making some kind of mistake, but I can't find it.
This is in Oracle. The following works:
update gis.testdata set point=
sde.st_point (1,2,4326)
where testdatakey=35;
And the following doesn't work:
update gis.testdata set point=
sde.st_geomfromtext ('point(1 2)',4326)
where testdatakey=35;
The error I receive is:
SQL Error: ORA-00904: "SDE"."ST_GEOMFROMTEXT": invalid identifier
This syntax is supported in just about every example page I can find, it just doesn't work for me. I really want to use a function that just accepts the WKT. What am I missing here? Thanks for any help.