I have a use case where I need to make cross db queries in oracle. This typically can be done using a connection string such as this.
Trying similar through ormlite doesn’t work as i get ORA-01031: insufficient privileges error. Through other means it does work.
Is this just not implemented or is is possibly ignored or perhaps I’ve missed something all together.
Note: Oracle is a community provider which we don’t maintain or support ourselves. The last maintainers left these notes about the Oracle provider.
Connection errors like this are dependent on the ADO .NET driver, i.e. the OrmLite Oracle provider uses Oracle.ManagedDataAccess and Oracle.ManagedDataAccess.Core packages where it appears this connection string is for use with the System.Data.OracleClient library instead.