Skip to Content

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

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.

replied

Hi Kenneth,

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. 

-Patrick

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question