How to create a stored procedure in the MSSQL which is hosted in Outsystems' cloud?
Question

How to create a stored procedure in the MSSQL which is hosted in Outsystems' cloud?

mvp_badge
MVP
Solution

Hi Diyab,


Creating stored procedures is not supported from within the OutSystems platform, even though there are ways to call them in external databases you may be integrating with (see here how to do it). 


Being that said:

  • You can call a store procedure created in an external database (see link above);
  • You can create a store procedure in OutSystems database if you are on-premises although it is not recommended in OutSystems documentation (read more about it here);
  • You cannot create store procedures in OutSystems database in a cloud infrastructure.


Kind Regards,
João

Noted with Thanks!

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.