Skip to Content (Press Enter)
2017-10-19 17-43-31
Khalil Dahham
48Views
2Comments
Solved
[Oracle Connector P9] Run a procedure in current session
Question
Forge
oracle-connector-p9
Web icon
Oracle Connector P9 (O11)
Forge asset by João 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?

0
0
08 Oct 2019
Copy Link
2017-10-19 17-43-31
Khalil Dahham
Solution

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

See solution in context
Capture.PNG
0
0
25 Dec 2020
Copy Link
2024-10-25 08-47-19
Eduardo Pires

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

0
0
08 Oct 2019
Copy Link
2017-10-19 17-43-31
Khalil Dahham
Solution

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

Capture.PNG
0
0
25 Dec 2020
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.