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)

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

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

Product

SAP HANA, platform edition all versions

Keywords

HANA Studio, CREATE PROCEDURE, Could not execute, SAP DBTech JDBC, sql syntax error, tab, TAB , 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.