Stack Overflow
Stack Overflow

Questions tagged [odac]

Oracle Data Access Components are data access drivers and tools for Windows.

246 questions
2
votes
1 answer

Client application hangs when inserting into table on Oracle using ArrayBinding

Here is our environment: .Net version: 4.5 Database: Oracle 12.1.0.2 (odp.net) We are using LLBL "Adapter" but I don't think that has anything to do with the issue LLBLGen Pro version: 4.1 Llbl Gen Pro Runtime: 4.1.13.1213 When we do an…
Jeremy Schrader
  • 55
  • 1
  • 9
2
votes
2 answers

Asynchronous call in C# using Oracle.DataAccess (ODAC)

I am trying to make an asynchronous call to Oracle, but it gets executed synchronously. Please look at below code and tell me what I am doing wrong. (I've installed ODAC (ODTwithODAC1120320_32bit.zip) and use the Oracle.DataAccess.dll assembly for…
Thorsten Kettner
  • 89,309
  • 7
  • 49
  • 73
2
votes
1 answer

Oracle.DataAccess.dll getting copied to Debug\Release bin folders despite Copy Local = false

I have a .NET solution which contains multiple projects. All the projects which refer the Oracle.DataAccess.dll have set Copy Local = false. However, When I build the solution, the dll always gets copied to bin folder. I don't want the dll to get…
fgenc
  • 133
  • 1
  • 1
  • 7
2
votes
1 answer

ODP.NET: Oracle date formatting to "output-only" formats

I'd like to use Oracle date formatting in C#, such as in to_char(date, format), without database connection nor writing my own format interpreter. Sample application (I'm using Oracle Data Provider for .NET): namespace OracleDateToCharTest { …
Bru
  • 514
  • 3
  • 14
2
votes
1 answer

Oracle Client throws ArgumentException with ulong parameter

I need to insert a ulong (i.e., UInt64) number into an Oracle database, but am running into an ArgumentException. I'm inserting it into a NUMBER column, which I have assured myself should be able to store any number from 0 to 2^64-1. Here is a…
Jay Sullivan
  • 17,332
  • 11
  • 62
  • 86
2
votes
1 answer

Problems with .NET 4.5, Entity Framework and Oracle

I am working on an application (let's call it A, an ASP.NET MVC3 web site) in .NET 4.0, under Visual Studio 2010 and with Entity Framework and Oracle. Everything goes right. For an other application (let's call it B), I installed Visual Studio 2012,…
fharreau
  • 2,105
  • 1
  • 23
  • 46
2
votes
0 answers

ODAC/Entity Framework Model Update Issues

We are looking to introduce odac into our application but I am running into a number of issues and I can't seem to find any solutions that fix our issues. We are using an oracle database and trying to use ODAC 12c Release 1 (12.1.0.1.0) with Oracle…
Steve S
  • 41
  • 1
  • 2
2
votes
2 answers

Odac ORA-00911: invalid character

I am writing a C# code that connects to ODAC. I think my query got no errors, but I get this error, I don't know how to solve. This is my query comm.CommandText = "SELECT * FROM ZAEDBA WHERE USER_ID = '" + login_id + "' AND APPID…
msytNadeem
  • 173
  • 1
  • 4
  • 15
2
votes
3 answers

OracleConnection is throwing empty exception

I'm trying to connect to my Oracle Database from my new PC. I've just installed Visual Studio and the ODAC. But when I try to do a simple connect Im getting an exception with an empty message, empty source, empty number, just with the error code…
Laggel
  • 1,356
  • 3
  • 19
  • 36
2
votes
2 answers

Oracle stored procedure in .net 4.5

I'm trying to execute the following stored procedure in .net 4.5 PROCEDURE my_procedure ( a_cursor OUT t_cursor, return_value OUT VARCHAR2, a_type VARCHAR2, a_time DATE, …
randoms
  • 2,793
  • 1
  • 31
  • 48
1
vote
0 answers

Installing odac as a part of deployment package

Need to install ODAC components along with a Forms application. I am using VS2010 publish wizard to deploy the package to UNC path. How could I deploy and install ODAC components (odp.net4) and Insta-client in a single deployment package ?
TonyP
  • 5,655
  • 13
  • 60
  • 94
1
vote
2 answers

How to find the query sent through ODAC to Oracle Database when using Entity Framework (EF)

I am using Oracle ODAC for EntityFramework. I am trying to develop a sample silverlight application using entityframework. I have add my domainservice through which I am publishing my entities. I am UI's code behind file. I have written the…
coolcake
  • 2,917
  • 8
  • 42
  • 57
1
vote
1 answer

Entityframework core 7 with Oracle database in .Net 6 application

Can I use entityframework core 7 with oracle database for an exiting tables and views? I just want to add the tables and views to the context and will not add migration or change anything through the .net 6 application.
Alaa Adel
  • 33
  • 7
1
vote
2 answers

Installing ODAC for .Net

I have Visual Studio.Net 2008 in my Windows XP machine. I have Oracle 10g client. As one of my applications uses ODAC, I need to install ODAC now. The latest version of ODAC is ODAC 11.2 Release 3 (11.2.0.2.1) with Oracle Developer Tools for Visual…
acadia
  • 2,619
  • 18
  • 55
  • 72
1
vote
1 answer

Cannot see Oracle database using OLE DB

I am trying to connect to a Oracle 12c database from Excel 2016 using 64-bit ODAC 12,2c Release 1 for windows x64. I go to get data and choose Oracle Provider for OLE DB, in Data Link Properties page I fill in details, with the user database…
Danny
  • 2,771
  • 5
  • 30
  • 42
1 2 3
…
16 17