The System.Data.OracleClient namespace is the .NET Framework Data Provider for Oracle. The .NET Framework Data Provider for Oracle describes a collection of classes for accessing an Oracle data source in the managed space. Using the OracleDataAdapter class, you can fill a memory-resident DataSet, query it, and use it to update the data source.
Questions tagged [system.data.oracleclient]
71 questions
60
votes
5 answers
ORA-00911: invalid character
I create two table in my oracle (11g) database like this:
create table "test" ("id" int);
create table test ("id" int);
Then in my C# program there is a problem :
OracleConnection conn = new OracleConnection(-myConnectionString-);
…
XlbrlX
- 703
- 1
- 6
- 10
32
votes
5 answers
OracleCommand SQL Parameters Binding
I have a problem with the binding of the below parameter. The connection works because I had tested it without using parameters. However, the value of the query before being executed is still using '@userName' instead of 'jsmith' for example.
What…
Ryan S
- 3,034
- 15
- 45
- 75
20
votes
4 answers
Issues calling stored procedure from C# with large CLOB
I'm not the first to have these issues, and will list some reference posts below, but am still looking for a proper solution.
I need to call a stored procedure (Oracle 10g database) from a C# web service. The web server has an Oracle 9i client…
chiccodoro
- 13,709
- 16
- 83
- 129
11
votes
4 answers
How to connect with System.Data.OracleClient to oracle db with windows authentication?
With Oracle SQL Developer I can put / -character to Username and leave password empty and I get connected. I have OP$MYWINDOWSUSERNAME user created in database.
EDIT: SQL Developer does not work if I check OS Authentication-checkbox (empties and…
char m
- 6,390
- 14
- 58
- 96
9
votes
2 answers
How to tell System.Data.OracleClient to use the 64 bit Oracle Driver
I am trying to run a .NET application which uses System.Data.OracleClient on a Win7 x64 workstation. The workstation has a 32bit Oracle client installed, which leads to the following error message:
Attempt to load Oracle client libraries threw…
chiccodoro
- 13,709
- 16
- 83
- 129
9
votes
4 answers
How to establish a OracleConnection without making use of the obsolete OracleConnection Class
What's the 'new' way of establishing a OraConnection?
Microsoft defines several classes as obsolete.
https://msdn.microsoft.com/en-us/library/system.data.oracleclient.aspx
I used to make use of something along those lines:
string queryString =
…
SighteD
- 107
- 1
- 1
- 10
8
votes
3 answers
ORA-12571: TNS:packet writer failure with ASP.NET
My development team is experiencing numerous ORA-12571: TNS:packet writer failure errors using ASP.NET 3.5 and 4.0 against Oracle 11g. These errors are inconsistent as to when they occur, and are generated by numerous applications. This exception…
dretzlaff17
- 1,629
- 3
- 19
- 24
7
votes
7 answers
Is there a way to force OracleCommand.BindByName to be true by default for ODP.NET?
Since the System.Data.OracleClient library has been deprecated, we are in the process of migrating our code base to use Oracle Data Provider for .NET (ODP.NET) instead. One of the issues that we have encountered is that the System.Data.OracleClient…
rjzii
- 13,621
- 12
- 79
- 116
6
votes
2 answers
When will be Oracle Database support for Dotnet Core available?
I want my DotnetCore 2.0 application to connect to Oracle, however, I am not able to find any official documentation from Oracle support. It was expected to release by the end of the year 2017 as per this link…
Prasanjeet Debnath
- 252
- 3
- 12
5
votes
5 answers
The type or namespace name 'OracleClient' does not exist in the namespace 'System.Data'
When trying to run my code, I receive the following error:
CS0234: The type or namespace name 'OracleClient' does not exist in the namespace 'System.Data' (are you missing an assembly reference?)
I have included references to System.Data.dll and…
jaredk
- 898
- 5
- 23
- 35
4
votes
2 answers
Correct way to use DbConnection, DbTransaction with connection pooling, transactionScope and dependency injection?
I have a Oracle database and I'm using the Oracle.ManagedDataAccess.
In some cases I will need to do actions in a single transactions, but often not.
I'm not sure what the best way to handle DbConnection objects within a single TransactionScope.
I…
Ingó Vals
- 4,468
- 14
- 57
- 108
4
votes
4 answers
The type or namespace name 'OracleConnection' could not be found
I am getting this error every time I try to debug my program:
CS0246: The type or namespace name 'OracleConnection' could not be found (are you missing a using directive or an assembly reference?)
This occurs on the declaration private readonly…
jaredk
- 898
- 5
- 23
- 35
3
votes
1 answer
Oracle Managed DataAccess connection object is keeping the connection open
I'm using Oracle.ManagedDataAccess Nuget package version 18.3.0. I tried many things. I tried to dispose everything I can think of, even oracle parameters objects. And wrapped everything inside a using block but to no avail. The only thing that…
Mahmoud
- 1,211
- 1
- 16
- 30
2
votes
2 answers
System.data.OracleClient with 32 bits oracle client driver on Seven 64 bits Operating system
I have a Web application migrating from asp.net 1.1 (VS 2003) to Asp.net 2 ( VS 2008).
I have a problem to execute Oracle connexion on the new version . The dev environnement is 64 bits Seven. When generate application with all CPU , i have a…
Benoit Durtaut
- 29
- 1
- 3
2
votes
0 answers
Wrapper .Net Framework to Core: System.Data.OracleClient
Background
I am currently facing the problem that my ASP.Net Core 5.0 Application is suddenly required to use a special library (from an external provider) for communicating with a database. Unfortunately, this library targets Framework 4.7.2.
An…
mabe
- 33
- 2