Skip to Content
0

Issue with Anonymous SQL Block with parameters in SAP HANA SQL Script

Dec 09, 2017 at 04:15 PM

83

avatar image

Hello Experts,

I am trying to use Anonymous SQL block in SAP HANA SQL console with parameters and its throwing syntax error.

Could not execute 'DO (IN in_var NVARCHAR(24)=> 'A') BEGIN end;' SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "(": line 1 col 4 (at pos 4)

I am using SAP HANA 1.O SP10, Is this a limitation with my HANA version?

Regards,

Anubhav.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Florian Pfeffer
Dec 11, 2017 at 08:42 AM
0

Signatures for anonymous blocks are not available in HANA 1.0 SPS10, they are introduced with HANA 1.0 SPS12 (check blog post SAP HANA SPS 12: New Developer Features; Database Development.

Regards,
Florian

Share
10 |10000 characters needed characters left characters exceeded