Stack Overflow
Stack Overflow

Questions tagged [odp.net]

Oracle Data Provider for .NET (ODP.NET) features optimized ADO.NET data access to the Oracle database.

Oracle Data Provider for .NET (ODP.NET) features optimized ADO.NET data access to the Oracle database. ODP.NET allows developers to take advantage of advanced Oracle database functionality, including Real Application Clusters, XML DB, and advanced security.

ODP.NET makes using Oracle from .NET more flexible, faster, and more stable. ODP.NET includes many features not available from other .NET drivers, including a native XML data type, self-tuning, RAC-optimized connection pooling, promotable transactions, and Advanced Queuing.

ODP.NET home page for news, downloads and help: http://otn.oracle.com/dotnet

1322 questions
7
votes
4 answers

How to configure DbContext to work with Oracle ODP.Net and EF CodeFirst?

I'm trying to work with EF CodeFirst under Oracle with ODP.net. This is my DbContext class: public class MyCEContext : DbContext { public DbSet Persons { get; set; } protected override void OnModelCreating(DbModelBuilder…
fcaldera
  • 584
  • 1
  • 6
  • 18
7
votes
2 answers

The type Database cannot be constructed. You must configure the container to supply this value (EntLib 5 + ODP.NET)

I use ODP.NET and version 4.1 of the Enterprise Library, vs 2008. And all is OK. Now, migrate using ODP.NET Oracle.DataAccess 4.112.2.0 and version 5.0.414.0 of the Enterprise Library, vs 2010, .net 4.0. Oracle.DataAccess 4.112.2.0 EnterpriseLibrary…
Kiquenet
  • 14,494
  • 35
  • 148
  • 243
7
votes
4 answers

Unable to load DLL “OraOps10.dll”

I am running into peculiar issue. I am developing a windows based application which connects to Oracle database. For initial testings, I have created installer and tested on different machines that I have. Each machine has Oracle Client installed…
Sudhakar Chavali
  • 809
  • 2
  • 14
  • 32
7
votes
4 answers

ODP.NET Core - Scaffold DB-Context

I am working with oracles odp.net core beta 3. Specifically, The dll is Oracle.ManagedDataAccess.Core.2.12.0-beta3. The project is to create a web api that sits on top of an oracle instance. My question - Is the command "Scaffold-DBContext"…
LCaraway
  • 1,257
  • 3
  • 20
  • 48
7
votes
5 answers

When opening an oracle connection, connection object is null

I am trying to connect to an oracle database in my controller: using Oracle.DataAccess.Client; using Oracle.DataAccess.Types; // Other code OracleConnection con; con = new OracleConnection(); con.ConnectionString = "DATA…
Mr Man
  • 1,498
  • 10
  • 33
  • 54
7
votes
3 answers

Oracle.DataAccess still try to access oraops12.dll after uninstall

First I have both 11 and 12 oracle client on my machine. But when i try to use 11g version of oracle.dataacess.dll . I already remove a 12c register on regedit and stop service and machince.config related. but the program was throw "Unable to load…
LLF
  • 668
  • 3
  • 10
  • 27
7
votes
4 answers

How can I update data in CLOB fields using a >> prepared query << with ODP (Oracle.DataAccess)?

I'm trying to execute a prepared sql query which updates CLOB fields in an Oracle 10g database (10.2.0.1). If I execute the following query from inside SQL Developer and supply the values for the placeholders, there is no prblem. If I however…
Tim Meyer
  • 12,210
  • 8
  • 64
  • 97
7
votes
4 answers

ODP .NET behaves weird

The application itself described in my previous question. On the DAL side I use Oracle.ManagedDataAccess, Version=4.121.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342 Here is connection string: User id=usr;Password=pwd;Data…
kseen
  • 359
  • 8
  • 56
  • 104
7
votes
1 answer

Unicode Parameter on Oracle Connectionstring

Why does not Oracle ODP recognize the parameter Unicode=true and Devart's Provider does? WHen I have data containing the string : "ñãõ,éóúý" , my asp.net application shows "???,????" if I'm using Oracle's ODP. WHen I try to put the attribute…
ClayKaboom
  • 1,833
  • 1
  • 22
  • 42
7
votes
5 answers

Cant Map SYS_REFCURSOR in Entity Framework

I am trying to access a Stored procedure on Oracle 11g through Entity Framework. I can access stored procedures which returns scalars and those returns correct value. But when using SYS_REFCURSOR for returning a result set, the OUT parameter is not…
Aneesh Mohan
  • 1,077
  • 8
  • 17
7
votes
6 answers

Handling null values in OracleCommand parameters

I'm trying to determine how to specify null as a parameter value in an OracleCommand using the following C# code. I've excerpted the relevant bits, but basically the point is if sal_id comes in with the value 0 it should be stored as null. I've…
Dan U.
  • 1,357
  • 3
  • 12
  • 19
7
votes
4 answers

Tables from second schema are not visible in Entities Wizard

I want to add ADO.NET Entity Data Model to my project. I am using Oracle database and Oracle ODP.NET to connect to the database. I need to query from two schemas. So I configured my connection to use two different Schemas (using the information I…
Adil Mammadov
  • 8,476
  • 4
  • 31
  • 59
6
votes
1 answer

ODP Oracle.DataAccess.DLL reference 32/64 bit

I have a .NET 3.5 assembly that references ODP (Oracle.DataAccess.dll), building in Visual Studio 2010. Copy Local = False, Specific Version is false. The path is C:\[ORACLE_BASE]\product\11.2.0\client_1\ODP.NET\bin\2.x\Oracle.DataAccess.dll The…
Stealth Rabbi
  • 10,156
  • 22
  • 100
  • 176
6
votes
4 answers

Oracle.Dataaccess is in the GAC. Can I control the version I use?

I have a XCOPY deployable .NET application using Oracle.DataAccess (ODP.NET). We also deploy the Oracle Instant client in the application directory. Everything works OK, but I worry.. From the Oracle ODP.NET FAQ: Beginning with ODP.NET 10.1.0.3,…
Arve
  • 7,284
  • 5
  • 37
  • 41
6
votes
5 answers

Oracle connections not closing

We have ASP.NET app that connects to oracle database with odp.net. Lately we started to experienced some performance issues. It seems that Oracle connections do not close and eventually pile up until it crash our website. As a first step we did a…
baba-dev
  • 2,582
  • 6
  • 27
  • 32
1 2 3
…
88 89