we try to migrate from oracle devart data provider to odp.
we use "Oracle.ManagedDataAccess.Core" Version="23.3.1-dev" with Oracle DB 19c.
with devart, there is an option for executing a custom command once a db-connection is established. (https://docs.devart.com/dotconnect/sugarcrm/Devart.Data~Devart.Common.DbConnectionStringBuilder~RunOnceCommand.html) this command is not executed when a pooled connection is used.
we use that command to set a number of session-relevant informations (like role privs ‘set role xyz’). this command should only run once.
does ODP provide a comparable option?