Skip to Content (Press Enter)
Back to Ideas
32
Like
Follow Idea
Stored Procedures in integration Studio
1242Views
8Comments
On our RadarOn our Radar
Data & Integrations
Possibility of importing stored procedures as we already do for tables and views. This stored procedures should map into Actions with the input and output parameters.
15 Feb 2013
Copy link to comment
This would be very helpfull and the same could been done with the databaseactions
11 Jun 2015
Copy link to comment
This would be awesome!
16 Jun 2015
Copy link to comment

Hi Vasco,

While indeed there's margin for improvement in how Stored Procedures can be called, currently it is possible to use them inside OutSystems. You can search the Forge for existing connectors to do that (like Oracle Connector), you can use the RuntimePublic.Db API inside an extension to do that or you can use a SQL node to do that. The last link includes a discussion about these various possible ways.


Best regards,

Pedro Guimarães

25 Jul 2018
Copy link to comment
Merged this idea with '(MSSQL) Stored Procedures as Objects' (created on 18 Aug 2017 15:55:09 by Daniel Brooks)
02 Nov 2018
Copy link to comment

When adding an external database via Integration Studio, it would be great if we could also integrate Stored Procedures as executable objects/entities within Outsystems.



This comment was:
- originally posted on idea '(MSSQL) Stored Procedures as Objects' (created on 18 Aug 2017 by Daniel Brooks)
- merged to idea 'Stored Procedures in integration Studio' on 02 Nov 2018 16:37:30 by Fernando Moitinho
18 Aug 2017
Copy link to comment
Merged this idea with 'Stored Procedure,Function,Package and View in Integation Studio' (created on 06 Aug 2019 14:04:56 by Arkyadeep Bharadwaj)
12 Oct 2020
Copy link to comment

Hi Team

Possibility of importing stored procedures as we already do for tables and views for On Premises Environment. This stored procedures should map into Actions with the input and output parameters.

with help of Integration also we can create new Stored Procedure,View,User Defined function and also import the Existing Stored Procedure,View,User Defined function.



This comment was:
- originally posted on idea 'Stored Procedure,Function,Package and View in Integation Studio' (created on 06 Aug 2019 by Arkyadeep Bharadwaj)
- merged to idea 'Stored Procedures in integration Studio' on 12 Oct 2020 04:52:33 by Daniël Kuhlmann
06 Aug 2019
Copy link to comment
2018-10-29 13-00-29
Magda Pereira
Changed the category to
Integration


This comment was:
- originally posted on idea 'Stored Procedure,Function,Package and View in Integation Studio' (created on 06 Aug 2019 by Arkyadeep Bharadwaj)
- merged to idea 'Stored Procedures in integration Studio' on 12 Oct 2020 04:52:33 by Daniël Kuhlmann
16 Sep 2019
Copy link to comment