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

[#1]

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

[former_member182302]

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

Regards,

Krishna Tangudu

[Former Member]

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

[Former Member]

Thanks Hinnerk for yor response.

Do you know any work around on this..?

Thanks.

Regards,

Harshawardhan

[Former Member]

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