1714270 - CREATE PROCEDURE fails in SAP HANA Studio with syntax error for correct code

Symptom

You run a CREATE PROCEDURE statement in SAP HANA Studio for code that is syntactically correct and still receive an error message like:

Could not execute 'CREATE PROCEDURE avg_shop_sales ( IN shop_id INTEGER , OUT avg_shop_sales avg_shop_sales_type) ...' in 532 ms 786 µs Started: 2012-05-03 02:57:31.
SAP DBTech JDBC: [257] (at 152): sql syntax error: line 5 col 9 (at pos 152)

Environment

SAP HANA Studio (confirmed for revisions 25, 26 and 27)

Product

SAP HANA, platform edition all versions

Keywords

KBA , HAN-STD-DEV-MOD , SAP HANA Analytical Modeling , HAN-DB , SAP HANA Database , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.