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
5
votes
1 answer

Can SSIS use the Oracle ManagedDataAccess client?

I've found the Oracle.ManagedDataAccess.Client driver library to be much easier to use and deploy in my .NET applications than the standard ODP.NET 250mb+ Oracle client library. Is there any way the Managed version of the Oracle driver can be used…
Matt
  • 3,676
  • 3
  • 34
  • 38
5
votes
2 answers

The Entity Framework provider type 'Oracle.ManagedDataAccess.EntityFramework' could not be loaded

I am trying to connect to Oracle using the Oracle Data Provider.NET (ODP.NET) using Entity Framework v6 in an MVC application. I have installed ODP.NET from here: https://www.nuget.org/packages/odp.net.entityframework/6.121.1-beta I have configured…
Martin
  • 293
  • 1
  • 3
  • 15
5
votes
1 answer

Oracle returns decimal for a certain NUMBER(4) column

I am executing a query using ODP.NET. The query selects a lot of columns from a table, including several NUMBER(4) columns. When executing the query against a local dev 10.2 instance, all NUMBER(4) columns are returned as instances of Int16. This is…
Alvaro Rodriguez
  • 2,820
  • 2
  • 33
  • 38
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
4 answers

PLS-00306: wrong number or types of arguments error in C#

We are using an Oracle stored procedure in a C# program, which was working fine until we added the 'v_nameurn' variable. Here's the Oracle procedure: create or replace procedure stats_By_Date ( v_SDate IN varchar2, v_EDate IN varchar2, …
Nick
  • 3,745
  • 20
  • 56
  • 75
5
votes
2 answers

Second insert fails because of returning into output parameter (OracleParameter)

I am trying to insert two rows into a table (sequentiel). The first insert command is executed without any trouble. The second insert command gets stuck in the ExecuteNonQuery() part. When I remove the returning part (OracleParameter with Direction…
hy13
  • 115
  • 1
  • 7
5
votes
5 answers

Oracle oci.dll in ASP.NET bin directory can't be deleted/doesn't work

I followed the directions here: http://splinter.com.au/blog/?p=156 in an attempt to use a newer version of ODP.NET without installing the Oracle 11g client. I followed everything, so far, except for restarting IIS. However, this has caused some…
Bob
  • 7,851
  • 5
  • 36
  • 48
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
5
votes
1 answer

Oracle ODP.NET Managed Driver running 50-100% slower in 64bit than in 32bit

I just switched some NUnit test projects from x86 to AnyCPU and started to run them in 64bit runtime using nunit-console.exe instead of nunit-console-x86.exe. This resulted in some 50-100% longer test duration to my great surprise. I can easily…
Buthrakaur
  • 1,821
  • 3
  • 23
  • 35
5
votes
4 answers

ODP.NET : Parameter Types "cached" on identical CommandText

I'm currently evaluating Oracle's ODP.NET DataProvider and I ran into a problem that popped up in one of our testcases: When the same command text is executed with different parameter types, the parameter type of the first executed command is used…
Linky
  • 605
  • 8
  • 24
5
votes
3 answers

OracleBulkCopy does not support Triggers

My software needs to insert about 5000 records into Oracle database at once, so I used OracleBulkCopyto do this. My table use trigger to auto increment primary key. But the OracleBulkCopythrow "ORA-26086: direct path does not support triggers"…
hieund
  • 356
  • 1
  • 6
  • 16
5
votes
1 answer

How do I integrate ODP.NET into Repository classes?

My domain model provides e.g. following object Report : IEntity. I usually retrieve Oracle user defined type object (or collection types) form stored procedures. For all types C# classes are generated by the ODP.NET Visual Studio Custom…
Marco Mayer
  • 197
  • 2
  • 10
5
votes
1 answer

Error: Could not load file or assembly 'Oracle.ManagedDataAccessDTC' or one of its dependencies

Background I have a solution containing a Console project and an MVC4 Webapp. Both Reference Oracle.ManagedDataAccess (the managed ODP.NET data access provider). The reference is to the same file. Neither reference Oracle.ManagedDataAccess DTC. In…
SeanKilleen
  • 8,809
  • 17
  • 80
  • 133
5
votes
1 answer

c# datatypes -> oracle datatypes

I like to save different c# data types in a Oracle database (int, decimal, double, string, Guid, …). Does anyone have a table showing what oracle data types to use? I have found tables showing what c# data types to use for different oracle data…
Rolf
  • 1,219
  • 2
  • 13
  • 23
5
votes
6 answers

OCIEnvCreate failed with return code -1 but error message text was not available with ODP.net

I'm trying to study ORP.net and looking over this article on Deploying ODP.NET with Oracle Instant Client. I have downloaded and copied all DLLs in project as the article explains, however on the testing step, when the app is built I get the…
Nate
  • 827
  • 3
  • 18
  • 29
1 2 3
…
88 89