Scalar type not allowed : SQLSCRIPT

sql sap hana
Sangamesh Hs picture Sangamesh Hs · Jan 8, 2014 · Viewed 7.3k times · Source

With limited knowledge of SQL, I write a procedure on HANA database and here is small part of my code.
enter image description here

WHen I run the following I get an error Error creating procedure;scalar type is not allowed: line 25 col 39 (at pos 1037) at ptime/query/checker/check_proc.cc:383. What is the scalar variable is specifying about? I am stuck please help.

Answer

Twinkles picture Twinkles · Jan 8, 2014

Just a guess, in line 32 you have

SELECT :ORGID_ARTIKEL into ...

Perhaps you mean

SELECT "ORGID_ARTIKEL" into ...

Related questions

How to convert a string to date in SAP HANA SQL select statement?

How do i convert a string '20120215' to a date format YYYY-MM-DD (2012-02-15) in a SQL SELECT statement? I am using SAP HANA SQL.

Read More
Combine LIKE and CONTAINS in SAP HANA

Consider the following entries in my table: red apple yellow apple apple green red aple appel yellow Several people have populated this table using a non-consistend notation (the color before or after 'apple'), also entering some spelling errors. Now I …

Read More
How to convert BLOB to varchar with SAP HANA database using SQL

how do I cast a blob to varchar with SAP HANA database using SQL. (we need the column to be stored in blob - not TEXT - in else HANA automatically creates an index on this column. But we need …

Read More