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

Return Value of Oracle.DataAccess execute non-query (stored proc)

Return Value For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. For CREATE TABLE and DROP TABLE statements, the return value is 0. For all other types of statements, the return value is -1.…
SoftwareSavant
  • 9,467
  • 27
  • 121
  • 195
4
votes
1 answer

Oracle.DataAccess (ODP.NET) Array Binding "Value does not fall within the expected range"

my scenario i'm using ODP.NET oracle provider with c# 3.5, and i am trying to pass an array as parameter for a procedure...like this: var paramNames = new OracleParameter(); paramNames.CollectionType =…
user756037
  • 285
  • 1
  • 8
  • 20
4
votes
1 answer

ORA-21700: object does not exist or is marked for delete for Associative Array as input parameter called from ODP.NET

I have this package code on Oracle 12c CREATE OR REPLACE PACKAGE Support_Data_Types AS TYPE ttDate IS TABLE OF DATE END Support_Data_Types; PROCEDURE GetData ( tabDates IN SUPPORT_DATA_TYPES.TTDATE, ) AS BEGIN SELECT…
hardywang
  • 4,864
  • 11
  • 65
  • 101
4
votes
4 answers

Oracle Column/Value size Issue

I'm using ODP.NET and Oracle 10g to transfer data from a datatable to a db table. The problem i'm facing is when trying to insert a value into a NUMBER(12,3) column. The value is 100100100,55 - i get the error : Error in row '1' column…
maephisto
  • 333
  • 8
  • 21
4
votes
3 answers

Managed ODP.NET Calls to PUBLIC Database Link tables cause TNS errors

Our application uses managed ODP.NET code to call a variety of Oracle Procedures. For one of our clients, who is using public database links, and referencing the linked tables within the procedure, that call is failing. Upon further testing, any…
Tom Halladay
  • 5,651
  • 6
  • 46
  • 65
4
votes
2 answers

Entity Framework with EF6 Runtime Exception 'Member Mapping specified is not valid'

I have just migrated to EF6 and here is what is happening. I have done everything suggested in any post on stackoverflow or oracle so I decided to open another question. 1) My Model is in a separated assembly. 2) I have done everything that I was…
CrazyBrazilian
  • 1,030
  • 1
  • 11
  • 15
4
votes
1 answer

Encountered "ORA-01745: invalid host/bind variable name" when using DbDataAdapter.Update() with ODP.NET

I have a table defined in oracle 11g with below statement: CREATE TABLE "TESTUSER"."TestTableOracleWriter" ("name" VARCHAR2(100 BYTE), "group" VARCHAR2(100 BYTE), "number" NUMBER(*,0), "creation" DATE, "sliceidentifier"…
Chasefornone
  • 747
  • 1
  • 7
  • 15
4
votes
1 answer

Why Oracle does not show as a drop down option in Entity Data Model Wizard but does in Server Explorer?

Oracle does not appear as a Data Source drop down list option. This has been asked here, but the answer there does not solve my problem (and for others as well, as per comments there). What's interesting is that in trying to add a Data Connection…
Veverke
  • 9,208
  • 4
  • 51
  • 95
4
votes
2 answers

How to use Oracle Entity Framework with no config file

Is it possible to create a code-first Entity Framework model that connects to an existing database using ODP.Net without having any settings in the app.config file? I have tried many different things. Currently I am setting DbConfiguration: …
Stephen Drew
  • 1,415
  • 19
  • 31
4
votes
1 answer

Oracle AQ Topic Queue dequeue with ODP.NET

I'm trying for the first time to dequeue from a queue on my company production environment by ODP.NET and C#. I used the official ODP.NET example to develop my client got from the installation examples folder. The queue is an Oracle AQ Topic (multi…
Antonio Petricca
  • 8,891
  • 5
  • 36
  • 74
4
votes
3 answers

How to know when to stop filling an OracleDataAdapter

I'm using the OPD.NET dll in a project that is accessing oracle. Users can type in any SQL into a text box, that is then executed against the db. I've been trying to use the OracleDataAdapter to populate a datatable with the resultset, but I want…
Will
  • 773
  • 1
  • 7
  • 24
4
votes
2 answers

Oracle.DataAccess.dll for .NET 4.0 in 32 bit Oracle Client install?

Below are two paths and the files present in the installation of Oracle client 32 bit (win32_11gR2_client.zip) for .NET 2.X and 4.X. When I installed the Oracle client, I chose not to take the default in two of the windows during the Install…
JustBeingHelpful
  • 18,332
  • 38
  • 160
  • 245
4
votes
1 answer

Entity Framework vs Oracle nested query limitations

I have the following Code First models (though in fact I'm just using EF to access a subset of an existing database; Table & Column attributes have been omitted from this example for brevity): public enum AlphaState { Unknown = '\0', Good = 'G', Bad…
Oblivious Sage
  • 3,326
  • 6
  • 37
  • 58
4
votes
1 answer

Is there anyway making ADO.NET work on .NET Core?

I need ODP.NET (Oracle Data Providers for .NET) on .NET Core but can't find anyway to make it work. When I reference OracleConnection or OracleCommand classes, the project needs System.Data assembly which I can't find in .NET Core. So isn't there…
Yves
  • 3,752
  • 4
  • 29
  • 43
4
votes
1 answer

Oracle.DataAccess not available for selection in Visual Studio 2013

I've recently set up a Windows 8.1 64 Bit Machine with Visual Studio 2013 (probably 32 bit, at least it installed itself at Program Files (x86)). I've also installed the Oracle 11.2.0.1 64 Bit Client with Oracle Data Provider for .NET. When I do…
Tim Meyer
  • 12,210
  • 8
  • 64
  • 97
1 2 3
…
88 89