Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

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

Comments
Post Details
Added on Jan 30 2024
8 comments
64 views