Questions tagged [odac]

0

votes
0

answer
7

Views

Updating edmx from VS 2017 showing error (Oracle database)

I am trying to update my edmx file using VS 2017 but each time I click on Update model from database option it is showing me the below error . In my system ODTwithODAC1120320_32bit is installed. I could update the edmx from VS 2010 successfully. Now I have installed ODAC for VS 2017 from link bu...
Arunprasanth K V
1

votes
2

answer
712

Views

Why does OraNet.dcu have no corresponding .pas file?

I have a related post - Assertion failure in DBAccess.pas but thought this was worth asking separately. We are licensed for the full source-code release of DevArt ODAC but have been experiencing tremendous difficulties performing an upgrade. In the course of investigating this I have noticed that t...
Hugh Jones
1

votes
3

answer
6k

Views

Return of Oracle Stored Procedure using OracleDataReader (ODAC)

I have a problem with output data from Oracle Stored Procedure using OracleDataReader(Oracle.DataAccess.Client). Procedure: procedure LOAD_BL_REQ_2(P_XML CLOB, P_XML_OUT out CLOB) is BEGIN P_XML_OUT := 'TEST1111'; exception when others then P_XML_OUT := 'LOAD_BL_REQ: Error'|| SQLERRM; END; C#...
2

votes
0

answer
562

Views

Why does ODAC Connection.open() sometimes raise an OracleException?

I catch an exception with empty message just at Connection.Open() line. the error code:-2147467259 the stack trace: at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean...
Masoud Sedghi
1

votes
2

answer
34.7k

Views

How to Install “Oracle Data Access Components (ODAC)” on Windows Server 2003 R2?

I recently installed "32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio" on my computer (Windows 7, 64bit). Everything seems fine and I can develop and run my application in Visual Studio 2010 and IIS 7. Now, when I deploy my application to the Server, it rais...
Tohid
5

votes
12

answer
40.2k

Views

OracleMTSRecoveryService failed to start?

i am getting this error while starting OracleMTSRecoveryService : Could not start the OracleMTSRecoveryService service on Local Computer. Error 1: Incorrect function.* Also during installation of ODAC service start failed. OracleXETNSListener is also not starting. i have reinstalled ODAC but problem...
Talal
4

votes
1

answer
417

Views

Multiple 'Or' statements in EF expression

Given a list of filter parameters in the form of: public class filterParm { public int age { get; set; } public string name { get; set; } } Where: var parms = new List { new filterParm {age = 22, "phil"}, new filterParm {age = 19, "dave"}, new filterParm {age = 31, "nick"} }; How do I write an expr...
philreed
5

votes
1

answer
44.1k

Views

ODP Oracle.DataAccess.DLL reference 32/64 bit

I have a .NET 3.5 assembly that references ODP (Oracle.DataAccess.dll), building in Visual Studio 2010. Copy Local = False, Specific Version is false. The path is C:\[ORACLE_BASE]\product\11.2.0\client_1\ODP.NET\bin\2.x\Oracle.DataAccess.dll The version is 2.112.3.0, (Runtime v.2.0.50727). I have O...
Stealth Rabbi
1

votes
5

answer
26.9k

Views

Java Runtime Environment was not found at bin\javaw.exe

When I tried to install ODAC component in Windows Server 2008 machine, it thrown below error. "Java Runtime Environment was not found at bin\javaw.exe. Hence the Oracle Universal Installer cannot be run. Please visit http://www.javasoft.com and install JRE version 1.4 or higher and try again" I foun...
lavanya b
2

votes
3

answer
46.6k

Views

ORA-24338: Statement handle not executed

i'm using Delphi 7, Oracle 10, and ODAC Components. From the LoadTrainResult method I'm calling a storedProc. procedure TfrmTrain.LoadTrainResult; begin StoredProc.StoredProcName := 'PTRAIN.QTRAIN'; StoredProc.Prepare; try StoredProc.ParamByName('P_COURSE').AsString := CurrentSe...
user1469630
3

votes
4

answer
2k

Views

Getting “cannot insert NULL into (”schema“.”table“.”column") when column is not null

Whenever I try to create a new myObj in mySchema, it keeps telling me that ID is null, but when I run the debugger, the debugger tells me the object I'm adding has no NULL values. It works on my colleague's machine, but not on mine... MyObj myObj = new myObj() { ID = 1234, } container.AddObject("MyO...
Bob.
2

votes
3

answer
11.1k

Views

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 which is -2147467259. OracleConnection Prueba; Prueba...
Laggel
2

votes
2

answer
1.6k

Views

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 = '" + app_id + "' ;"; Can any one figure out what is wrong in here?
msytNadeem
2

votes
0

answer
249

Views

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 Developer Tools for Visual Studio. In our model we...
Steve S
4

votes
1

answer
6.3k

Views

Understanding Oracle database and ODAC installation

I want to use Oracle XE DB in my ASP.NET MVC project. I installed Oracle 11g XE on same machine where is VS running. Installation completed succesfully in C:\oraclexe. Everything as expected, i was able to connect to DB via Server Explorer using default .NET oracle data acces provider. But i want to...
sanjuro
3

votes
3

answer
6.1k

Views

Entity Framework wildcards & Linq

Is it possible to construct a valid Linq query which contains wildcard characters? I've seen various answers to this question which suggest using: .Where(entity => entity.Name.Contains("FooBar")) .Where(entity => entity.Name.EndsWith("Bar")) .Where(entity => entity.Name.StartsWith("Foo")) OR constr...
philreed
2

votes
1

answer
950

Views

Delay / Lag between Commit and select with Distributed Transactions when two connections are enlisted to the transaction in Oracle with ODAC

We have our application calling to two Oracle databases using two connections (which are kept open through out the application). For certain functionality, we use distributed transactions. We have Enlist=false in the connection string and manually enlist the connection to the transaction. The proble...
Chathuranga Wijeratna
1

votes
3

answer
2.5k

Views

How to connect to oracle database with ODAC c#

I am using this code but getting an error of 'Object reference not set to an instance of an object.' at con.open() ? what am I doing wrong ? I have already download and installed ODAC component version 10 , 11 ,12 trying each one at the failure of the latest one but still same error using Oracle.D...
phpnet
23

votes
3

answer
44.5k

Views

How can I deploy a .NET application that uses ODAC without installing the whole component to the user?

I have written a C# application that connects to an Oracle 10g database. Using Oracle Data Access Component 11.2 "ODAC", it works perfectly on my machine. And now I want to deploy the application and install it in another "clean machine" that has the .NET Framework only! And I don't want to install...
3oon
3

votes
2

answer
10.2k

Views

ORA-00932: inconsistent datatypes: expected DATE got NUMBER

I am using Oracle Data Access from .net and my query is as command.CommandText = "select * from table1 where expirydate =:EXPIRYDATE"; command.Parameters.Add("EXPIRYDATE", OracleDbType.Date, DateTime.Today,ParameterDirection.Input); var results = command.ExecuteScalar(); I get the following error "...
MicroMan
2

votes
2

answer
861

Views

EntityFramework 6 with Oracle: Is there a “standalone” ODAC (i.e. without ODBC), and does every client PC need to have it installed?

While my VS 2013 Update 4 installation is running I decided to ask some questions that are bothering me and which are potentially easy to answer as I couldn't test myself yet (due to having had an older VS version up until now). Also, I don't have much experience with Oracle DB's at all, I just had...
InvisiblePanda
2

votes
2

answer
2.6k

Views

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, a_id VARCHAR2, a_arg1 VARCHAR2, a_from...
randoms
13

votes
4

answer
13.6k

Views

ODAC 12c and Entity Framework 6

Can anyone tell me if the Oracle Data Access Components 12c is compatible with Entity Framework 6? The Oracle website is a nightmare for documentation and cannot find any references on how to resolve this. I have an existing project which I am trying to upgrade to ODAC 12c and EF6 but I'm getting t...
philreed
2

votes
2

answer
1.2k

Views

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 my calls to Oracle. Before I used the deprecated Sys...
Thorsten Kettner
7

votes
0

answer
3.5k

Views

Error 0152: No Entity Framework provider found for 'Oracle.DataAccess.Client' ADO.NET provider

I have Windows 7 x64, Visual Studio 2012 with the 'ODAC 11.2 Release 5 and Oracle Developer Tools for Visual Studio (11.2.0.3.20)'. Then I connected to Oracle db, create .edmx model. But when I'm trying to use EF to operate some data var ent = new Entities(); var res = ent.table1.ToList(); Error hap...
Alex Zaitzev
35

votes
7

answer
48k

Views

Oracle ODP.Net With Entity Framework 6 - Entity framework database compatible provider could not be found

I am trying to build an MVC 5 Web application with Entity Framework 6 that works on Oracle Database , am trying to use ODAC 12c Release 3 which includes support for Entity Framework 6 Code First and Code First Migrations; NuGet, .NET Framework 4.5.2; and ODP.NET, Managed Driver XML DB. As per http:...
Wasef Anabtawi
3

votes
0

answer
47

Views

c++ builder devart odac

I am using the ODAC components designed by the devart company with embarcadero C++ builder 10.2. Now I want to define an own class, which should be able to establish a connection to an oracle database. So I want to use the TOraSession component inside of my own class but without using the VCL. The c...
Hoeh
2

votes
1

answer
1.1k

Views

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 Insert(always into different tables which we are using for the...
Jeremy Schrader
2

votes
1

answer
2.9k

Views

Error PRVF-7536 Installing Oracle ODAC 12c Release 4 (12.1.0.2.4)

I'm trying to install the Oracle ODAC 12c Release 4 (12.1.0.2.4) on my Windows 10 Pro x64 machine but I'm facing a very weird error in the "Perform Prerequisites Checks" step, AFAIK the error is telling me I'm using the wrong package for my machine's architecture, but I'm pretty sure my machine is x...
Anon Dev
2

votes
2

answer
15.4k

Views

Difference between Oracle Client and ODAC

What is the difference between installing the full Oracle Client and an Oracle Odac install? Which will I need to do .NET development on my dev workstation and which will I need on the web application server that will connect with the Oracle database on another server?
Vince Miccio
2

votes
1

answer
76

Views

Adding dll to release

We have completed development of our first big application in C# and we need to export it. Our app should work by just opening the .exe file. There may be some other files in Source folder, it does not matter(dll can be next to .exe). We released it in Visual Studio and it work just fine on our com...
Daniel Švarc
5

votes
1

answer
2.5k

Views

Oracle SqlError: Protocol Violation / OALL8 is in an inconsistant state

I'm getting Protocol Violation and OALL8 is an inconsistant state exceptions trying to execute SELECT queries, but only on SOME of my tables. I first noticed this in a test application that I wrote that did a SELECT * FROM SOMETABLE. It would get through several hundred records and then just lock u...
Stealth Rabbi
3

votes
4

answer
2.4k

Views

ROWNUM returns as “invalid identifier”

I am running a very basic select against an oracle database (not sure of the version). SELECT * FROM ACCOUNTING WHERE ID = 123456 ORDER BY DATE I want to return only the most recent record. So I have tried ... SELECT ROWNUM, * FROM ACCOUNTING WHERE ID = 123456 ORDER BY DATE SELECT * FROM ACCOUNTING...
8

votes
3

answer
3.1k

Views

ODAC 11.2 Release 4 (11.2.0.3.0) throwing “Oracle 11.2.0.2.0 does not support APPLY” exception

I'm using Entity Framework with the new ODAC that oracle just released. My problem is that some of my queries that were working in previous beta releases stopped working in this new release version. Here's an example: IQueryable query1 = m.DBContext.SYS_PERFIL.Where(T => T.SYS_UTILIZADOR.Where(TT =>...
Pedro Fonseca
8

votes
2

answer
3.5k

Views

Get value of Oracle OUT parameter from a stored procedure call using Dapper.NET

Edit: Using the Execute method instead of the Query/QueryMultiple methods, my OUT_SUCCESS parameter now has an AttachedParam with with an OracleParameter that has the returned value. So this would work if, for instance, I only needed to retrieve non-cursors parameters. Then I could use Execute for p...
tacos_tacos_tacos
2

votes
1

answer
2k

Views

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, which installed the new version of the .NET framew...
fharreau
3

votes
1

answer
11.2k

Views

Can I use 32 bit Oracle Developer Tools with x64 ODAC in VS2010?

From the Oracle website here: http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html This is for their latest Oracle Data Access Components, 64-bit ODAC 11.2 Release 4 (11.2.0.3.0) for Windows x64. I want to use the developer tools (ODT) but they aren't available in 64 bit (...
DaveN59
2

votes
1

answer
3.3k

Views

ODAC & C# - TNS: Connect timeout occurred - Connecting only through VS2005 debugger

I am new to Oracle, and there is an issue I am facing. When I run the application from IDE - Visual Studio 2005, The database connection is established smoothly, but when I run an installed version of the app, the DB connection fails and I get a TNS: Connect timeout occurred error. I tried with SQLN...
Sreedevi J
4

votes
1

answer
5.6k

Views

Unable to install Oracle Developer Tools for Visual Studio

I have already installed Visual Studio 2015 and also installed Oracle12c latest version database and I'm trying to install Oracle Developer Tools for Visual Studio but it is showing the following error: On clicking next button it is showing the following error: What can I do to install Oracle Develo...
Developer SuRu
2

votes
0

answer
427

Views

SSL/wallet error trying to access Oracle DB from SSRS

I'm trying to access a third party Oracle database from SQL Server Reporting Services. I had it working on previous versions of SQL Server and Oracle ODAC, but it's been several years. I'm now being forced into an upgrade, and when I try to create the data source in SSRS, I get the following error:...
user1013571

View additional questions