Log in to AnswerLog in to Follow
Diyab Rehman
13Views
2Comments
Solved
How to create a stored procedure in the MSSQL which is hosted in Outsystems' cloud?
Question
Database

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

0
0
on 12th Mar
João Marques
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

1
0
on 12th Mar

Noted with Thanks!

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