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

Getting output buffer from DBMS_OUTPUT.GET_LINES in C#

I'm trying to get the output from the DBMS_OUTPUT.PUT_LINE() method in my anonymous PL/SQL block through C#. I've looked at a couple of other related questions here, but am still having trouble. The return code of executing the anonymous block is…
Jimenemex
  • 3,104
  • 3
  • 24
  • 56
11
votes
4 answers

Oracle query is slow (or fails) from .NET app but is fast from SQL Developer

We use ODP.NET to perform queries on Oracle databases, and normally it works fine. There is a particular database, and a particular view in that database, though, that we just can't complete a query on from .NET. For example: SELECT…
Greg Smalter
  • 6,571
  • 9
  • 42
  • 63
11
votes
3 answers

Execute an oracle Function that returns a reference cursor in C#

I have an oracle package with a procedure that has a in out reference cursor. My understanding is that this is pretty standard. What I didn't like is the fact that I had to write a ton of code to just see the output. So I asked this question and it…
Conrad Frix
  • 51,984
  • 12
  • 96
  • 155
11
votes
3 answers

ORA-12154 error trying to connect using ODP .NET

ORA-12154 error trying to connect using ODP .NET UPDATE: Wernfried's answer fixed it for me. Create an environment variable TNS_ADMIN=D:\oracle\product\12.1.0\dbhome_1\network\admin Sqlplus reads TNS_ADMIN from Registry but ODP.NET Managed…
Derek
  • 7,615
  • 5
  • 33
  • 58
11
votes
6 answers

EF + ODP.NET + CLOB = Value Cannot be Null - Parameter name: byteArray?

Our project recently updated to the newer Oracle.ManagedDataAccess DLL's (v 4.121.2.0) and this error has been cropping up intermittently. We've fixed it a few times without really knowing what we did to fix it. I'm fairly certain it's caused by…
Tom Halladay
  • 5,651
  • 6
  • 46
  • 65
11
votes
3 answers

OracleBulkCopy Class in Oracle.ManagedDataAccess.dll?

I am using OracleBulkCopy Class with reference to Oracle.DataAccess.dll. I want to use Oracle.ManagedDataAccess.dll for easy deployment. But then I got build error "OracleBulkCopy not found" Does anyone know why OracleBulkCopy is not included in…
Shawn
  • 5,130
  • 13
  • 66
  • 109
11
votes
2 answers

Oracle number to C# decimal

I know there are several threads and posts regarding this issue in the internet and I've read them (not every article, I have to admit) but none of them did fully satisfy me. My situation: I'm using ODP.net (dll version 2.111.6.0) to access the…
robert.oh.
  • 644
  • 2
  • 5
  • 13
11
votes
4 answers

C# ODP.NET Load file or assembly

I recently started testing on a C# (4.0) app that uses ODP.NET (Oracle.DataAccess 4.112.3) I set this project to target any platform and publish the app. When I run the program on the client machine I receive: Could not load file or assembly…
Wjdavis5
  • 3,952
  • 7
  • 35
  • 63
10
votes
1 answer

Unable to add performance counters of Oracle OLEDB provider

At my server, I am using SqlClient to connect to SQL Server, Oledb for old apps connecting with Oracle and ODP.NET for new apps connecting with Oracle. I am seeing in perf counters: .NET Data Provider for Oracle .NET Data Provider for Sql…
Imran Qadir Baksh - Baloch
  • 32,612
  • 68
  • 179
  • 322
10
votes
1 answer

Weird behavior in Entity Framework Linq in string EndsWith method

Background I have a table that contains only one column: Name. There are only four rows in it, say | Name | | test1.com | | test2.com | | test3.com | | test4.com | Problem If I query var email = "a@test2.com"; Table.Where(x =>…
Moozz
  • 609
  • 6
  • 18
10
votes
4 answers

DbProviderFactories for .NET Error

I am having trouble getting the ODP.NEt library to work with the .NET DBProviderFactories. I am getting the following error with this code: _DBFactory = DbProviderFactories.GetFactory(providerName); An error occurred creating the configuration…
theringostarrs
  • 11,940
  • 14
  • 50
  • 63
10
votes
4 answers

"ORA-03135: connection lost contact" when inserting large file

I'm trying to do an insert with a potentially large amount of binary data into a remote Oracle (11g) database using Entity Framework (ODP.Net). It works fine for really small files (<5 KB), but for larger ones (e.g. 44 KB) I get an error:…
Ishmael Smyrnow
  • 942
  • 1
  • 9
  • 27
9
votes
3 answers

ODAC 11.2 Release 4 (11.2.0.3.0) throwing "Oracle 11.2.0.2.0 does not support APPLY" exception

I'm using Entity Framework with the new ODAC that oracle just released. My problem is that some of my queries that were working in previous beta releases stopped working in this new release version. Here's an example: IQueryable query1 =…
Pedro Fonseca
  • 449
  • 5
  • 10
9
votes
3 answers

No Oracle DataSource in Entity Data Model Wizard

I am using ODP.NET and I need generate ORM from my database. I have installed: Visual Studio 2010 Ultimate ODAC1120250Beta_EntityFramework_x64.zip In Server Expolorer I can see Data Source for Oracle Database and I am able connect to remote oracle…
312k1t
  • 269
  • 1
  • 4
  • 10
9
votes
3 answers

How to execute a update statement using Oracle ODP.Net in C#

I am using Oracle.DataAccess.Client to work with Oracle database in my ASP.Net application. There is no help documentation in MSDN for ODP.Net and Oracle's documentation is really really bad. I am not able find the answer to this simple question. Is…
Karthik Murugesan
  • 1,100
  • 3
  • 13
  • 25
1 2
3
…
88 89