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

Kerberos error when connecting to Oracle database in .NET Core

I have an application created using .NET Core 3.1 which needs to connect to an Oracle database, the connection code is very straightforward and I'm connecting using a username and password: var con = new…
Jackson
  • 5,627
  • 2
  • 29
  • 48
5
votes
1 answer

SSIS AdoNet ODP Managed connection Issue where Tables are not showing up in the drop down

When I click the drop down in the source editor after entering a valid connection (and successfully testing said connection), I get the following error message: Could not retrieve the table information for the connection manager 'xxxx'. Could not…
Jacob Alley
  • 767
  • 8
  • 34
5
votes
1 answer

How to connect with ODP.NET Core to Oracle 9i database - Managed Driver

When i try to connect to Oracle 9i db, i get always ORA-1017 invalid username/password; logon denied. On Oracle 10g or higher all is well. ODP.NET Core: 2.18.3; ASP.NET Core: 2.1.403 ConnectionString: "Data…
gopek
  • 686
  • 7
  • 20
5
votes
5 answers

ORA-01400 can't insert null value... but I am NOT inserting null value!

I am trying to insert data in an Oracle table by using ODP.NET from a C# application, but I am getting an ORA-01400 can't insert null value error for a column in which I am NOT inserting a null value. This is the stripped down version of the…
Konamiman
  • 49,681
  • 17
  • 108
  • 138
5
votes
1 answer

ODP.NET Integrated Security Invalid Connection String Argument

What am I missing? [ArgumentException: 'Integrated Security' is an invalid connection string attribute] …
Travis Heseman
  • 11,359
  • 8
  • 37
  • 46
5
votes
4 answers

Why doesn't ODP.NET 11 xcopy deployment work on a machine with Oracle DB 10 installed?

I have an app that uses a local version of ODAC 11 below the directory that the .exe file is in. The idea is that we want our app to use the local ODAC 11 regardless of what else the user has installed on her machine. Oracle.DataAccess.dll is in…
Josh Kodroff
  • 27,301
  • 27
  • 95
  • 148
5
votes
2 answers

Oracle Odp.Net unreported error on call to procedure in invalid package

I just got my worst maintenance nightmare : a silent error. I was calling a procedure using Odp.Net inside a custom package, and the procedure call failed silently without any exception being thrown (verified using both step by step debug and a…
Michel
  • 282
  • 1
  • 4
5
votes
2 answers

ODP.NET + Unexpected traffic on port 6200 (Oracle Notification Services)

We've got a client using our product, which includes a windows service built using .NET 4+, Entity Framework, and ODP.NET. For some reason in one particular installation, but not any other, the windows service appears to be generating traffic on…
Tom Halladay
  • 5,651
  • 6
  • 46
  • 65
5
votes
1 answer

Invalid binding for Oracle UDT in procedure parameter

I'm attempting to call a procedure that takes a custom data type of table of numbers as one of the parameters. Here is the definition of the type: create type num_list as table of number; And the definition of the procedure: create or replace…
Omar
  • 39,496
  • 45
  • 145
  • 213
5
votes
2 answers

Row count from OracleDataReader

Can any one tell me how to find row count from OracleDataReader in .net 2.0?
Pradeep
  • 4,612
  • 10
  • 38
  • 50
5
votes
2 answers

ODP.NET Managed ConnectionPool closes/opens every 3 minutes

We are using the latest Official ODP.NET Managed (Published: 2015-10-14 | Version: 12.1.2400) from Oracle to a Oracle 12 database (non RAC) configuration and we are unable to keep database connections alive for more than typically < 3 minutes. Our…
Jonny Bekkum
  • 93
  • 1
  • 6
5
votes
3 answers

ODP.Net Managed Driver - ORA-12704: character set mismatch in generated code

I am currently using the Oracle Managed Driver (v12.1.2400) as my Entity Framework driver, and am currently seeing a ORA-12704: character set mismatch error during execution. The LINQ->SQL code I am using is as follows: from c in…
Nick
  • 1,116
  • 2
  • 12
  • 24
5
votes
2 answers

Fluent NHibernate - Configure Oracle Data Provider ODP

I am brand new to NHibernate and Fluent NHibernate and I am trying to get the following confguration to work. private static ISessionFactory CreateSessionFactory() { return Fluently.Configure() .Database( …
Paul Speranza
  • 2,302
  • 8
  • 26
  • 43
5
votes
2 answers

Can odp.net pass a parameter to a boolean pl/sql parameter?

Is it possible to correctly pass an OracleParameter to a boolean parameter in a pl/sql stored procedure?
haymansfield
  • 5,419
  • 4
  • 34
  • 51
5
votes
3 answers

DBNull issue with Oracle 11g ODP.Net provider

We are facing problem in checking output parameters for “DBNull”. “DBNull” value returned by Oracle stored procedure or function is treated as “null” string by oracle 11g client/ODP.Net provider. This works fine with oracle 10g client as it returns…
Hiscal
  • 633
  • 2
  • 8
  • 14
1 2 3
…
88 89