Skip to Content

Error: Syntax for Spatial Functions must be in Objective-style

Hello Experts,

I am unable to call a SQL procedures which involves spatial function because of error "Syntax for Spatial Functions must be in Objective-style"

below is my Procedure & Call Statement.

This has remained unanswered on forum. Can anyone help.

Adding Gerrit Simon Kazmaier

As suggested by Jon-Paul Boyd in below thread


Thanks.

Harshawardhan

SPATIAL_HANA.JPG (52.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Nov 05, 2014 at 05:57 PM

    Hello Harshawardhan

    This is a known limitation with HANA <= SPS8 / Rev84.

    Your procedure works fine in HANA SPS09 which will be delivered soon.

    Best regards,

    Hinnerk

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Harshawardhan Ghatge

      Hi Harshawardhan

      If you are on SPS07 which is our first release with spatial capabilities, a workaround is not really possible. For SPS08, you can work with WKT-strings and ST_GeomFromWKT instead of native ST_Point columns, but i would recommend to wait for SPS09.

      Best regards,

      Hinnerk

  • Nov 10, 2014 at 02:48 PM

    You may just want to try using Dynamic SQL and check once if it is solving.

    SAP HANA: Calculating distance between 2 cities using Geo-Spatial functions

    Regards,

    Krishna Tangudu

    Add comment
    10|10000 characters needed characters exceeded