Stack Overflow
Stack Overflow

Questions tagged [system.data.oracleclient]

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.

71 questions
62
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
  • 743
  • 1
  • 6
  • 10
37
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,210
  • 17
  • 48
  • 79
21
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
  • 14,407
  • 19
  • 87
  • 130
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
  • 7,840
  • 14
  • 68
  • 117
10
votes
5 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
  • 117
  • 1
  • 1
  • 11
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
  • 14,407
  • 19
  • 87
  • 130
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,699
  • 3
  • 19
  • 24
8
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
  • 14,236
  • 12
  • 79
  • 119
7
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
  • 272
  • 3
  • 13
5
votes
2 answers

Can we use System.Data.OracleClient in .Net against Oracle 19c?

so we migrated Oracle 12.2 to 19c and the Asp.Net app that connects to oracle service is now failing with the following error: Oracle 12560: TNS Protocol Adapter Error before anything, I'd like to confirm that the .net dll System.Data.OracleClient…
user12762335
  • 51
  • 2
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
  • 986
  • 5
  • 21
  • 37
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,788
  • 14
  • 65
  • 113
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
  • 986
  • 5
  • 21
  • 37
3
votes
2 answers

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…
Rickless
  • 1,377
  • 3
  • 17
  • 36
3
votes
0 answers

FetchSize Equivalent in System.Data.OracleClient.OracleDataReader

In Oracle.DataAccess.Client.OracleDataReader we have property called "FetchSize". Is there anything with same functionality in "System.Data.OracleClient.OracleDataReader". Could any one suggested.
Britto Raj
  • 401
  • 1
  • 5
  • 15
1
2 3 4 5