How to use stored procedures

[Former Member]

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

[former_member226419]

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

[thamizharasan]

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.

[marcel_scherbinek]

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.