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
9
votes
4 answers

Compare only time from datetime in entity framework 6 with odp.net Oracle 12c

I am using entity framework 6 with oracle and Sql. Timespan datatype is not working with oracle. so i changed datatype to datetime. now i want to compare only time in datetime with Linq query. ex. var db0010016 = _idb0010016Rep.GetAll().Where(e =>…
dvirus
  • 201
  • 2
  • 21
9
votes
4 answers

ODP.NET: Avoiding Connection Timeouts with Connection Pooling

At one site I can connect to the Oracle Database with SQL Developer, leave it idle for a long time (e.g., > 60 minutes), and return, and it's fine. At a second site, if it stays idle for more than 5-10 minutes (I haven't counted exactly), it leaves…
Andy Jacobs
  • 933
  • 3
  • 10
  • 18
9
votes
1 answer

How to return a RefCursor from Oracle function?

I am trying to execute a user-defined Oracle function that returns a RefCursor using ODP.NET. Here is the function: CREATE OR REPLACE FUNCTION PKG.FUNC_TEST (ID IN TABLE.ID%type) RETURN SYS_REFCURSOR AS REF_TEST SYS_REFCURSOR; BEGIN OPEN…
Gady
  • 4,935
  • 8
  • 38
  • 48
9
votes
3 answers

Cannot drag tables from model browser into edmx design surface

I am using ODP.NET. I have added an ADO.NET model to the project. That way, an edmx file was created. I chose "create from database" and after I selected the tables and click finish, edmx design surface appeared empty, however, the model browser…
jstuardo
  • 3,901
  • 14
  • 61
  • 136
9
votes
2 answers

Oracle.DataAccess.Client.OracleException ORA-03135: connection lost contact

I have a .Net service that connects to an Oracle database on every request. It works fine at the beginning, but after some number of requests I start getting: Oracle.DataAccess.Client.OracleException ORA-03135: connection lost contact at…
Grzenio
  • 35,875
  • 47
  • 158
  • 240
9
votes
3 answers

ODP.NET Managed - Unable to find requested .Net Framework Data Provider

Using Visual Studio 2013, I've added the latest version of ODP.NET Managed to a project using Nuget: Install-Package odp.net.managed http://www.nuget.org/packages/odp.net.managed/121.1.2 Now, when I try to run the following code: Database db =…
user1077685
9
votes
5 answers

Entity Framework 6 (5) connection to Oracle

I am attempting to write a Data Access library for our suite of applications that use Oracle in .net. We currently use NHibernate and are thinking of migrating away as it appears to not be supported all that well. I am working with Visual Studio…
SoftwareSavant
  • 9,467
  • 27
  • 121
  • 195
9
votes
1 answer

ODP.NET Managed Driver Performance Counters missing in perfmon

How do I enable the performance counters for ODP.NET Managed Driver in perfom in order to be able to monitor them? Currently I am unable to see the category "Oracle Data Provider for .NET" in perfmon at all. I've tried to register the counters from…
metalheart
  • 3,740
  • 1
  • 23
  • 29
9
votes
2 answers

How to use an Oracle Associative Array in a SQL query

ODP.Net exposes the ability to pass Associative Arrays as params into an Oracle stored procedure from C#. Its a nice feature unless you are trying to use the data contained within that associative array in a sql query. The reason for this is that…
ScottCher
  • 14,651
  • 6
  • 26
  • 25
9
votes
2 answers

Entity Framework with Oracle using odp.net not taking parameters in linq query

I am using EntityFramework with Oracle using odp.net. The parameterized sql query does not work. var orderCode = "XYZ"; var set = ctx.Database.SqlQuery( "Select * from dwh.Orders where OrderCode = '{0}'" , orderCode ); (or) var set1…
Jonna
  • 1,625
  • 1
  • 18
  • 38
9
votes
3 answers

How do I map from Oracle UDTs with ODP.NET without using OracleObjectMappingAttribute?

The data access layer in our application is going to be using the UDT functionality of Oracle. We will only be passing UDT objects to and from the database. At the moment, we generate the custom classes using the function provided with ODP.NET…
David
  • 682
  • 2
  • 9
  • 15
9
votes
3 answers

Oracle.DataAccess mismatch error

I installed the odp.net 32 bit installation for Visual Studio 2012. I set a reference to the Oracle.DataAccess.dll and my connection to Oracle seems to be working. When I build the project (.net 4) I get the following error. The project is set to…
MrMVCMan
  • 490
  • 2
  • 7
  • 20
9
votes
1 answer

GC.Collect() and PerformanceCounter

A colleague of mine is convinced there is a memory leak in Oracle's odp.net ado.net implementation. He has written a test program to test this theory and is doing the following after calling dispose on each object in order to determine how much…
zaq
  • 2,571
  • 3
  • 31
  • 39
8
votes
1 answer

OracleBulkCopy vs SQL*Loader Performance

I am seeing some significant performance differences between OracleBulkCopy (ODP.NET) and SQL*Loader when the Oracle server is on another machine. I have a very basic table in Oracle with three columns (one BINARY_FLOAT, two NUMBER(18,0)). There are…
Adrian Brown
  • 250
  • 3
  • 9
8
votes
3 answers

ORA-12571: TNS:packet writer failure with ASP.NET

My development team is experiencing numerous ORA-12571: TNS:packet writer failure errors using ASP.NET 3.5 and 4.0 against Oracle 11g. These errors are inconsistent as to when they occur, and are generated by numerous applications. This exception…
dretzlaff17
  • 1,699
  • 3
  • 19
  • 24
1 2 3
…
88 89