Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 11, 2017 at 08:42 AM

    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

    Add comment
    10|10000 characters needed characters exceeded