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

ORA-12899 error in CHAR(1) field, but I'm sending only a 'C'

My Oracle database returns the error: ORA-12899 - Value too large for column TIT.ESTADO_CIVIL (actual: 2, maximum: 1) But I'm very sure that the sended value is an unique char 'C'. Anyone knows why this is happening? (I'm using C# with…
Keyo
  • 119
  • 2
  • 8
4
votes
3 answers

Upgrading EntLib 4.1 to 5 with Oracle.DataAccess.Client

I am upgrading a project from EntLib 4.1 to EntLib 5. I've skimmed through the Migration Guide, changed all the references and updated all the config files to point to EntLib 5. All worked fine accept Oracle database access. With the config…
Michael Lloyd Lee mlk
  • 14,561
  • 3
  • 44
  • 81
4
votes
2 answers

Oracle Data Access ORA-06512: character string buffer too small

When I call GetTest I get this error: string buffer too small ORA-06512 This my c# method: public string GetTEST() { using (var conn = new…
FrankSharp
  • 2,552
  • 10
  • 38
  • 49
4
votes
1 answer

Oracle Custom Class Wizard fails to generate custom c# class from Oracle User Defined Datatype

I am trying to generate custom .NET classes from an Oracle User-Defined Type from Visual Studio Server Explorer (Oracle Developer Tools for Visual Studio and Oracle Data Provider for .NET are installed). I created a basic User Defined Type using…
George Philip
  • 704
  • 6
  • 21
4
votes
1 answer

Multiple resultsets from Oracle in Odp.net,without refcursors

SQL Server is able to return the results of multiple queries in a single round-trip, e.g: select a, b, c from y; select d, e, f from z; Oracle doesn't like this syntax. It is possible to use reference cursors, like this: begin open :1 for select…
James L
  • 16,456
  • 10
  • 53
  • 70
4
votes
0 answers

Odp.net connection pool failing when accessed by multiple threads simultaneously (ORA-24550: signal received: Unhandled exception: Code=e0434f4d)

I have problems Open()ing multiple OracleConnections simultaneously with multiple threads. Example A, a single-threaded example, works fine: for (int i = 0; i < 100; i++) { OracleConnection oracon = new OracleConnection(oraconstr); …
Evgeniy Berezovsky
  • 18,571
  • 13
  • 82
  • 156
4
votes
1 answer

Oracle.DataAccess.Client.OracleCommand ExecuteReaderAsync

So because the OracleCommand class extends the DbCommand class it implements the Async versions of it's Execute methods. However, I cannot find any reference to that OracleCommand class supporting these methods from Oracle (I am using…
ChoptimusPrime
  • 433
  • 7
  • 15
4
votes
1 answer

Setting Oracle session variables prior to database read/write events in Entity Framework / ODP.NET

I have a situation where I need to set oracle session variables/context before read & write events happen (this is a requirement by the client and not negotiable). Where would be the best place to insert this code? I'm already overriding the…
Tom Halladay
  • 5,651
  • 6
  • 46
  • 65
4
votes
2 answers

How to get tracing info for binding variables passed through OracleParameter in ODP.NET?

After Googling a lot and not finding what I'm looking for I decided to ask this question. I'm using binding variables as demonstrated in this awesome article from 2005 titled The Values That Bind by Mark A. Williams, like this: OracleParameter…
Leniel Maccaferri
  • 100,159
  • 46
  • 371
  • 480
4
votes
1 answer

Does ODP.NET support EF Model-First with DbContext?

We're trying to use an Entity Framework Model-First approach with Oracle 11g and ODP.NET 11.2.0.3.20. We'd like to use EF 4.1 or EF 5.0 with DbContext. Short version: Has anyone managed to do that? Long version: On VS2010 and Entity Framework 4.0,…
Jonas Sourlier
  • 13,684
  • 16
  • 77
  • 148
4
votes
1 answer

Using ODP.NET to get a RECORD from PL/SQL function, without touching PL/SQL code

The title is pretty-self-explanatory: from a C# application, using ODP.NET, I'm trying to call a PL/SQL function that returns not a simple value, but a record. Unfortunately, I'm not authorized to add or change the PL/SQL code, so attempting to wrap…
Branko Dimitrijevic
  • 50,809
  • 10
  • 93
  • 167
4
votes
4 answers

How to connect to a remote Oracle database

I have to connect to a remote Oracle DBMS into my .NET C# web service Is request the client Oracle installation? Why? When you have to use ODP.NET Thanks
Safari
  • 11,437
  • 24
  • 91
  • 191
4
votes
1 answer

oracle clob parameter conversion to string hangs in asp.net

Please find this code. It is properly working on my local machine. It was copied to windows server 2008 (64bit). It was working fine for many days. But now, it is hanging and taking 20 minutes. Same code is working in my machine fast. If I convert…
user1676704
  • 41
  • 2
4
votes
1 answer

Creating 32-bit ODP.Net OracleConnection object is very slow

I'm using the Oracle ODP.Net 11.2.0.2 provider to connect to an Oracle database. When I run the following code as a Console application, the creation of the OracleConnection object takes over 2 minutes: using System; using…
JoshL
  • 10,737
  • 11
  • 55
  • 61
4
votes
2 answers

Oracle ODP.NET problems calling package procedure with parameters

Problem: Trying to call a packaged stored procedure, but the call is failing depending on the values of the parameters. ORA-06502: PL/SQL: numeric or value error ORA-06512: at line 1 Procedure Definition: procedure DUP_EXACT ( SSN in VARCHAR2,…
Tom Halladay
  • 5,651
  • 6
  • 46
  • 65
1 2 3
…
88 89