[Oracle Database] Transaction, Commit, Rollback?

[Oracle Database] Transaction, Commit, Rollback?

  

Hi, I'm used to Oracle DB concept of transaction.

But I don't see any commit or rollback action on Outsystems.

What is the scope of transaction in Outsystems, if in 1 server side logic there is multiple CRUD action, if one failed, is it:

- All tables will be rollback automatically?

- Tables are partially commited?

Can I use commit and rollback in SQL node?

Transaction are crucial for maintaining data integrity, so I hope I can use manual transaction commit and rollback and even savepoint (for partial rollback).

Thanks in advance.

Solution

Hi,


This is another question you could have found in the help-files.

V10 documentation is still a WIP, but 9.1 is an excellent way to find it also.


Still, to answer your question:

http://www.outsystems.com/help/servicestudio/9.1/index.htm#t=Using_Data%2FHandling_Transactions.htm


Solution