Skip to Content

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.

CP1.PNG (7.1 kB)
CP2.PNG (19.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 08, 2015 at 04:17 PM

    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

    Add comment
    10|10000 characters needed characters exceeded