How to create function, SP and trigger in Outsystem DB?

How to create function, SP and trigger in Outsystem DB?

  
Hi,

we have credential for our OutSystems Database, we able to perform Insert, Update and Delete operations in outsystem table.
But we can’t do Create new Store Procedures, function and trigger.
So please suggest me, how to create my own Store procedures, function and trigger in my OutSystems database.

Thanks
?Hitesh
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 :).