[Oracle Connector P9] Run a procedure in current session

Forge Component
(8)
Published on 2015-03-13 by Grazina
8 votes
Published on 2015-03-13 by Grazina

Hello,

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

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