Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

HANA Procedure Basics

Hi All

  I am trying to create a basic procedure in  HANA which has one input parameter and no output parameters..But it is throwing error as below

Repository: Encountered an error in repository runtime extension;error preparing statement create procedure "_SYS_BIC"."zcrmcoeteam/COUNTR" (  ) language SQLSCRIPT sql security definer reads sql data as  for oid {tenant: , package: zcrmcoeteam, name: COUNTR, type: 2}: sql syntax error: line 1 col 113 (at pos 113) at qp_gram.y:27854.

my code is as below.

BEGIN

for cnt in 0..5 DO

CALL ins_msg_proc('loop iteration:'||:cnt);

  END FOR;

END;

request your help in finding the problem.Also I have few questions

1.Is it possible to pass tables as IN arguments or only table type

2.How can we create a table type of some existing table.

3. Is it mandatory to have IN and OUT arguments.

Thanks

Santosh

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question