SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting unknown error with geometry:::STGeomFromText('POINT')

User_DXIV2May 23 2022 — edited May 23 2022

INSERT INTO LOC(GEOMETRY)
VALUES (geometry::STGeomFromText('POINT (33.893715019148885, 35.50527553491294)', 4326));

This is the simple code I have.
I just want to insert a geometry value but keep getting an unknown error.
Error at line 2/17: ORA-00917: missing comma ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220100", line 847 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220100", line 833 ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 1903

I do not understand where an missing comma error can be in the 2 lines of code. Can anyone help?

Added on May 23 2022

1 comment

282 views