ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Run Command once when connection is established (even when pooling is enabled)

Patrick KernJan 30 2024

Hi,

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?

thanks

Added on Jan 30 2024

8 comments

323 views