31
Views
2
Comments
Solved
[Oracle Connector P9] Run a procedure in current session
Question
Forge component by Grazina
8
Published on 13 Mar 2015

Hello,

When I call a function or procedure, it will open a new session. How can I make it run in the current transaction?

Rank: #3765
Solution

Leaving the connection name and other database credentials empty will run the procedure in the current database session.

Capture.PNG

Rank: #2275

Hi Khalil, i think you can set your transaction name in Outsystems flow and at begin your function or procedure set again for same transaction with something like that:

SET TRANSACTION NAME 'transaction_name';

Check Oracle documentation: https://docs.oracle.com/en/database/oracle/oracle-database/18/cncpt/transactions.html#GUID-7690181F-8293-47B9-ADC1-905BD9C3AF57

Rank: #3765
Solution

Leaving the connection name and other database credentials empty will run the procedure in the current database session.

Capture.PNG