Skip to Content

Adding objects to package or delivery unit

Hi All,

I am creating a stored procedure using SQL Editor since I could not figure out adding "with result view" keyword. However when I did this, I created the procedure against a schema, not a package. Is there a way to include such object into a package or directly to delivery unit?

Thanks,

Iwan

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Nov 20, 2012 at 07:42 PM

    Hi Iwan,

    I am not 100% if that would fit your purpose - but what about a scripted calculation view?

    That should technically create a procedure (wrapped by a column view).

    Best regards

    Thorsten

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Thorsten,

      Thanks for the hints. It works for my purpose. I do have a follow up question, is there a way to define output structure by referring to existing table type?

      in SQL Editor, i can specify (out out_var <existing table type>) where as when I create the procedure normally, I have to define each fields and its data type one by one.

      Regards,

      Iwan

  • Posted on Nov 21, 2012 at 01:13 AM

    Which revision of HANA are you using?

    In more recent SPS3 & SPS4 releases, you can create a Procedure under a Package.

    Just right click the Package and go to "New" menu, you should see the "Procedure" option.

    Anyways, why couldn't you use the "WITH RESULT VIEW" statement?

    Check the SQLScript guide if you have any issues:

    http://help.sap.com/hana/hana_dev_sqlscript_en.pdf

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.