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

1296 questions
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
  • 49,660
  • 12
  • 87
  • 144
11
votes
3 answers

Oracle.DataAccess.Client Dependencies

First of all, I want to use the Oracle.DataAccess.dll to use OracleBulkCopy. I want to know all the dlls that I need to be able to read from a database and then perform a bulkcopy in Oracle. Currently, we are using only one dll to perform all the…
billybob
  • 2,597
  • 6
  • 26
  • 50
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,451
  • 5
  • 44
  • 63
11
votes
2 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
  • 4,718
  • 11
  • 56
  • 97
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.
  • 636
  • 2
  • 5
  • 12
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,566
  • 7
  • 27
  • 60
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…
user960567
  • 28,664
  • 58
  • 165
  • 292
10
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,103
  • 8
  • 39
  • 62
10
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
  • 6,565
  • 3
  • 28
  • 47
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
  • 599
  • 3
  • 17
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
  • 4
  • 10
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
  • 1
  • 18
9
votes
3 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
  • 893
  • 2
  • 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,595
  • 7
  • 33
  • 46
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
  • 2,687
  • 10
  • 44
  • 101
1 2
3
…
86 87