Help with "Create Procedure" error
Hi, Can anyone tell me what's wrong with my sqlscript? I have an sqlscript trying to create a procedure and I keep getting an error. I am signed in as SYSTEM. I did not find anything online to help exactly. Thanks for any help with this.
Patrick Bachmann replied
I think you are stumbling with the same problem I first experienced when first writing HANA scripts. There are two ways to write scripts. It looks like you are doing this within HANA Modeler perspective and you are right-clicking a package and then choosing CREATE PROCEDURE. Well there are two ways to create procedures. Supposedly this way is limited and you can't do all the declarations etc that you are trying to do. What you need to do is goto SAP HANA DEVELOPMENT perspective, setup a repository, setup a project and then create your procedure here. My understanding is this is the new way to create procedures and that we should no longer create procedures the old way via Modeler perspective. I believe it was Thomas Jung who told me this. If you do a quick search for Thomas Jung and HANA procedures you will probably find a good tutorial on this.