Skip to Content (Press Enter)
UserImage.jpg
luis
2Views
3Comments
Searching for "stored procedure in slq server"
Question
I'd like to know if is possible import a stored procedure from a sql server application, or if
outsystem allow us to create a store procedure.

thanks for all the attention,


Luis Pereira

0
0
07 Nov 2007
Copy Link
2011-08-23 22-04-05
Tiago Simões
Staff
Hi Luis,

Yes, you can call a stored procedure using an advanced query with EXEC yourprocedurename provided that the OutSystems runtime user has permissions for it. Remember that you'll always need to define an output structure, even if the stored procedure does not return anything.

If you are doing new business logic (instead of reusing an existing sp) I would recommend you to do it in Service Studio, as stored procedures are usually a lot harder to maintain.

Cheers,
Tiago Simões
0
0
10 Nov 2007
Copy Link
2011-10-11 00-46-16
Diogo Cordeiro
Hi Tiago, do you know if it is possible to retrieve the output of a stored procedure with an advanced sql query? Input i believe, but output i'm quite ceptic...

Best Regards,

Diogo C S Cordeiro
0
0
11 Nov 2007
Copy Link
2011-08-23 22-04-05
Tiago Simões
Staff
Hi Diogo,

Yes it is, you just need to define an output structure with the same attributes as the stored procedure return.

Cheers,
Tiago Simões
0
0
11 Nov 2007
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.