Skip to Content
avatar image
Former Member

How to use stored procedures

I went thru tutorials on how to create stored procedures but I am confused as to where you use them. The tutorials execute the stored procedures via the SQL console but they do not provide any details on how I would use outside of the SQL console. Can someone please explain how I would use a stored procedure outside of the SQL consoled (for example, calculation view)?

Thanks.

Sandy

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Oct 22, 2015 at 12:39 PM

    As you mentioned the calculation view. If you create a new calculation view you can choose between scripted an graphical. When you have a scripted calculation view you can CALL a stored procedure within the calculation view.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 23, 2015 at 06:41 AM

    Hi Sandy,

    You can use stored procedures in odata services. For example you need to process some data before an insert/update/delete you can use the procedure to do the same.

    service{
         "SCHEMA_NAME"."TABLE_NAME" AS "COLLECTION_NAME"
         CREATE USING  "PROCEDURE_NAME"
         DELETE USING "PROCEDURE_NAME";
    }
    

    Regards,

    ThamizharasaN.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 23, 2015 at 01:08 PM

    Hi sandy,

    You can use them via odata or if you want to use them in calculation view , you can use in scripted calculation view by using simple call statement in the same.

    Br

    Sumeet

    Add comment
    10|10000 characters needed characters exceeded