Hi,

You'll need to create them directly in your DB using any IDE you like (Toad, Sql Developer, etc...).
But you can then use then in Outsystems through advanced queries, for example you can create an advanced query with just "exec SP_XXXX" and set the output structure to whatever that SP may return.

Hope it helped,
Hermínio

Hi,

When we create SP form my sql server menagement studio then this give me error "CREATE PROCEDURE permission denied in database 'MyDatabaseName'."

So How to enable this permission? please suggest.

Thanks
Hitesh

Hi Hitesh,

1 - Right-click the stored procedure, and click "Properties"
 
2 - Click the "Permissions" option, and then the "Search..." button on the right side.
 
3 - Type OSRuntime and click on "Check Names"
 
4 - Click Ok
 
5 - Check the "Grant" checkbox, on the "Execute" line, to give him execution permissions.

For more info check this link.

Hope it helps!

Hi,

still we getting same error. we are unable to set excute permission on MY user.

Please Set excution permssion on my user.

Thanks
Hitesh

Hi Hitesh,

This is a OutSystems user community. We can't set your database properties for you :).