Search code examples
hana

Hana Cloud, issue with stored procedure WITH RESULT VIEW

I would like to create stored procedure in Hana Cloud with option "WITH RESULT VIEW". Unfortunately , it generates an error and different adjustments (delete second output parameter, etc) doesn't help.

I appreciate if somebody suggests the root cause of the error. See the screenshot enter image description here

Thanks

second output parameter removed

view name changed

Solution

  • WITH RESULT VIEW is not available on SAP HANA Cloud. Check the documentation of CREATE PROCEDURE or the list of SQL/SQLScript incompatibilities between SAP HANA 2 and SAP HANA Cloud for more details.