Stack Overflow
Stack Overflow

Questions tagged [odp.net-managed]

The Oracle Managed DataAccess Provider is the .Net Native version of ODP.Net. It doesn't need a prior Oracle Client installation or have any dependency on the OCI library. Applications that reference it may therefore be built 'AnyCPU'.

110 questions
5
votes
2 answers

Case insensitive search using ALTER SESSION on ODP.NET/EF connections?

I've got some EF/LINQ statements that I need to be case-insensitive text searches, but our oracle database is case sensitive. How can I execute the necessary ALTER SESSION statement at the connection/command level so that it will affect the…
Tom Halladay
  • 5,651
  • 6
  • 46
  • 65
5
votes
2 answers

EF + ODP.NET: The specified value is not an instance of type 'Edm.Decimal'

I am using Oracle's managed ODP.NET client with Entity Framework. It's working fine. However I am having different behaviours in different servers. I am pretty sure it has something to do with DLL versions, but I could not find any differences so…
Pablo Santa Cruz
  • 176,835
  • 32
  • 241
  • 292
4
votes
0 answers

ASP.NET won't connect to Oracle via SSL, console app will. What's different?

I am trying to connect to a client's Oracle database over SSL using the managed ODP.NET provider. The client has provided a self-signed certificate which I have imported on the server. To test the connection, I created a console app which simply…
witters
  • 691
  • 1
  • 7
  • 20
4
votes
2 answers

ODP.NET Managed Trace File

I'm having an issue attempting to generate a trace file for an application. Attempting to troubleshoot an Oracle problem, but the trace file isn't being written. This is my app.config which gets moved to the Release folder as exename.app.config. …
Ctznkane525
  • 7,297
  • 3
  • 16
  • 40
4
votes
3 answers

Managed ODP.NET Calls to PUBLIC Database Link tables cause TNS errors

Our application uses managed ODP.NET code to call a variety of Oracle Procedures. For one of our clients, who is using public database links, and referencing the linked tables within the procedure, that call is failing. Upon further testing, any…
Tom Halladay
  • 5,651
  • 6
  • 46
  • 65
4
votes
0 answers

pass array of objects to oracle stored procedure using ODP.Net managed client

I have following Employee class in my web API. public class Employee { public string Name { get; set; } public string City { get; set; } } my web API receives the list of 50 employee records on each request and it needs to update those…
Raj
  • 95
  • 3
  • 8
4
votes
1 answer

Adding multiple oracle schemas in visual studio 2013 and EF

I have a serious problem that needs to be resolved. In my server explorer in VS2013, I set up a connection to the database with valid user and password credentials. So I have a schema called: Connect1, and it needs to have access to another schema…
sksallaj
  • 3,872
  • 3
  • 37
  • 58
4
votes
2 answers

Do I have to uninstall oracle unmanaged dataAccess (Oracle.DataAccess) before installing managed ManagedDataAccess (Oracle.ManagedDataAccess)

I am planning to move from oracle unmanaged data access client to managed data access client. Right now I have ODP.Net installed on my machine which contains the DLL - Oracle.DataAccess.dll. But I am planning to move to oracle's recently released…
user1812749
  • 67
  • 1
  • 2
3
votes
1 answer

Scaffolding an Oracle database with EF Core failing with logon denied error

I am trying to scaffold some classes from an Oracle database for use with a .NET Core Web API. I have installed the following nuget packages: Oracle.EntityFrameworkCore - v2.18.0-beta3 Oracle.ManagedDataAccess.Core - v2.18.6 I have tried scaffolding…
JB06
  • 1,881
  • 14
  • 28
3
votes
3 answers

How do I setup tnsnames.ora in asp.net core web application?

I have a small asp.net core 2.2 app that should access an oracle db; I'm using NuGet Oracle.ManagedDataAccess.Core (2.18.6), and it just works on my machine. When I deploy it to the windows server with IIS, I place a tnsnames.ora file in app's…
Tymur Gubayev
  • 468
  • 4
  • 14
3
votes
4 answers

Connection to Oracle using Oracle.ManagedDataAccess exception

I'm using the Oracle.ManagedDataAccess Nuget Package Version 12.2.1100 in my C# (>.NET 4.0) project. Everything works ok in my localhost but on the dev server I'm hit with this exception: Exception Message: ORA-12154: TNS:could not resolve the…
user94614
  • 511
  • 3
  • 6
  • 26
3
votes
0 answers

Unexpected connection state. When using a wrapping provider ensure that the StateChange event is implemented on the wrapped DbConnection

first time caller here... I'm writing a WebAPI application that connects to an Oracle database using Oracle.ManagedDataAccess. I'm using EF6 and I'm intermittently getting "Unexpected connection state. When using a wrapping provider ensure that the…
NeilCampbell
  • 43
  • 1
  • 6
3
votes
2 answers

"Test connection succeeded" but "An unexpected error occurred in the ODP.NET, Managed Driver"

I want to connect Oracle from Visual Studio 2015 Enterprise Update 3. After installed ODT For Visual Studio 2015, to add new connection with data provider Oracle Database (ODP.NET Managed Driver) popup seems weird, test connection succeeds even…
user3849479
  • 31
  • 1
  • 3
3
votes
2 answers

Using INSERT...RETURNING clause leads to ORA-12537

The problem is as simple as stated in question topic. I try to run some query using INSERT...RETURNING clause, which raises ORA-12537 exception when I try to execute it. The source is as follows: using ( OracleCommand command = new OracleCommand ()…
Aleksei Omelaienko
  • 568
  • 5
  • 19
3
votes
1 answer

Oracle.ManagedDataAccess for .Net 3.5

The question is: Is there a library with Oracle.ManagedDataAccess for .NET 3.5? Currently application uses.NET 4.0 but I must crate opportunity to use application on .NET 3.5 with independent Oracle library.
templaris
  • 221
  • 5
  • 11
1
2
3 4 5 6 7 8