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

ORA-08103 error on procedure

I have a procedure on Oracle that works perfectly fine if I call it from SQL Developer using this code: VARIABLE x REFCURSOR exec MY_PROCEDURE('par1', 'par2', 'par3', 'par4' ,:x); PRINT x; If I try to call it form my .Net app (using ODP.NET), I get…
Diego
  • 34,802
  • 21
  • 91
  • 134
5
votes
1 answer

How to use an Oracle Ref Cursor from C# ODP.NET as a ReturnValue Parameter, without using a Stored Function or Procedure?

I need help understanding if the way I'm trying to use a Ref Cursor as a ReturnValue Parameter for multiple records/values, with the PL/SQL just being the CommandText of an OracleCommand object and not in a Stored Procedure or Function, is even…
Paul
  • 387
  • 1
  • 6
  • 11
5
votes
1 answer

Specifying parameters in the Using clause of an Oracle Merge statement

Oracle's PL/SQL is fairly new to me, so I need some help understanding if the way I'm trying to use parameters in a Merge's Using clause is even possible. I'm working with Oracle 11g using ODP.NET for communication with an existing C# .NET 4.0…
Paul
  • 387
  • 1
  • 6
  • 11
5
votes
1 answer

"ORA-01012" error message when trying to connect to an Oracle database

Using C# and Oracle Data Provider for .NET (ODP) I made a long query to the database, then I end the connection on the server side using TOAD. After that, the subsequent calls to the database, even creating a new OracleConnection object, throw the…
Juan M. Elosegui
  • 6,471
  • 5
  • 35
  • 48
5
votes
1 answer

System.Reflection.RuntimeModule.GetTypes() error with ODP.Net and C#

I wrote a fairly complex C# application which accesses an oracle database via ODP.Net. I developed the application on a windows XP machine (32-bit) where I installed ODAC (32-bit). The application runs without a glitch on my development PC but…
edd
  • 933
  • 2
  • 11
  • 24
5
votes
3 answers

To close or not to close an Oracle Connection?

My application have performance issues, so i started to investigate this from the root: "The connection with the database". The best practices says: "Open a connection, use it and close is as soon as possible", but i dont know the overhead that this…
Ewerton
  • 4,046
  • 4
  • 30
  • 56
4
votes
1 answer

ODP.NET How to pass array of strings to an Oracle Stored procedure?

There's numerous question and confusing docs on the subject, but no luck so far. I've the following PL/SQL stored procedure; PROCEDURE PS_test( Liste1 Listcar, Liste2 Listcar, P_CURS_MESSAGE out CURSOR_REF_TYP ) Where the type Listcar is the…
Vinzz
  • 3,968
  • 6
  • 36
  • 51
4
votes
1 answer

Oracle ODP.Net and connection pooling

this is really two questions in one I guess. We've developed a .Net app that accesses an Oracle database, and have noticed that after changing the user's Oracle password, the app continues to work for a short time with the old password in the…
Andrew Stephens
  • 9,413
  • 6
  • 76
  • 152
4
votes
1 answer

Understanding Oracle database and ODAC installation

I want to use Oracle XE DB in my ASP.NET MVC project. I installed Oracle 11g XE on same machine where is VS running. Installation completed succesfully in C:\oraclexe. Everything as expected, i was able to connect to DB via Server Explorer using…
sanjuro
  • 1,611
  • 1
  • 21
  • 29
4
votes
1 answer

Parameter Delimiters

I have C# application we've been coding in ADO.NET. I've been using the IDbCommand, and IDbConnection interfaces to create cross-database code. It's all worked wonderfully so far (across Firebird, SQLite, SQL Server 2005, and 2008,…
Brian Deragon
  • 2,929
  • 24
  • 44
4
votes
3 answers

ODP.NET deployment without installation

I want to deploy a client application that uses Oracle's ODP.net but I don't want to install ODP.net on every machine. Rather I'd like to copy the managed dll oracle.dataaccess.dll on every machine and have the native dlls on which it depends…
mnrtyrpt123
  • 143
  • 2
  • 10
4
votes
2 answers

Problems with NHibernate and DateTime mappings

I'm having trouble with a query where I select records within a given timespan. The column I'm selecting from is of type DATE. I have mapped this column as a DateTime property, and the query works but is slow. The generated query looks like:…
dajoni
  • 103
  • 7
4
votes
6 answers

ORACLE and Entity Framework. Error:the specified store provider cannot be found in the configuration or is not valid

In my project I am using oracle and entity framework together.Both of my machines my developer machine win7 and my server win2008r2 I installed oracle beta entity framework and .net 4.0 framework. However my projects works on local machine and…
Yaya
  • 600
  • 1
  • 11
  • 28
4
votes
4 answers

Oracle ODP.NET Cursor Leak?

I'm running into an open cursor limit issue with using the following code. The open cursor limit on the oracle db is set to around 1000. The following code seems to hold onto the cursors even though I've got everything in a using statement (I…
chris
  • 128
  • 1
  • 2
  • 7
4
votes
3 answers

Could not load file or assembly 'Oracle.DataAccess' - Markup View

I am having a strange problem since installing the latest version of ODAC, 11.2.0.2.1. I installed both the 32-bit and 64-bit versions because I develop applications for both architectures. My computer is Win 7 64-bit. Since installing ODAC and…
Zach Green
  • 3,421
  • 4
  • 29
  • 32
1 2 3
…
88 89