Can i call store procedure in Standard/insert/update with other update statements?
You have dedicated option to make a stored procedure call.
Can you brief on why do you want to perform this action action on standard operations?
What i have to perform is that i need to extract some information from multiple tables and based on information, i need to update some information in multiple tables. While updating tables, i have 3 store procedure (which i believe is also updating some tables) that need to executes along with updation simultaneously. That is need to executes all at the same time and if any one of the statement or SP got erred, then need to rollback updates done by others.
Haven't tried this yet.
But probably yes you should be able to achieve this.
Reason being I have used Standard insert to run different queries and it worked flawlessly.
Retrieving data ...