How to connect to an Oracle Database using a legacy descriptor

Navigate to: Database Settings -> Advanced -> Ext Driver Options and add the key "oracle_legacy_descriptor".

The value must be a string. It can be either the absolute file path pointing to your descriptor file, or the raw descriptor string itself.

How to share SQL variables across multiple executions

Ensure that all executions occur within the same transaction.