Oracle Data Access Components are data access drivers and tools for Windows.
Questions tagged [odac]
246 questions
0
votes
0 answers
how to get data based on parameter from oracle to EF
I have to make up to 100 reports based on data that I have to retrieve from oracle providing some parameters to procedures/functions.
Now I am using ODAC and VS2010 to connect to oracle but I have a problem to create a FUNCTION IMPORT from either…
Andron
- 223
- 1
- 3
- 14
0
votes
2 answers
Assertion failure in DBAccess.pas
I am interested in upgrading a suite of software from ODAC v5 to v8.2.8.
One app in particular is causing problems. This application loads one of a set of secondary applications implemented as dlls.
LibHandle := LoadLibrary(PChar(dllname));
if…
Hugh Jones
- 2,706
- 19
- 30
0
votes
2 answers
Getting BIDS 2008 R2 to connect to Oracle using MSDAORA on Windows 8
I have a new dev machine, and I need to support legacy SSIS packages. The new machine is Windows 8 64 bit with a SSD primary drive (C:) and a regular HDD for data (D:). On it, I have installed BIDS 2008 R2 (and all the tricks to get it to work…
Scott
- 1
- 1
- 1
0
votes
0 answers
Entity Framework with ODAC
I use EF with ODAC and it's Oracle.DataAccess and Oracle.Web.dll version numbers are 2.112.3.0, but on the server the version number is 2.112.1.0. My web application always is giving this error message:
Unable to find the requested .Net Framework…
sada
- 584
- 2
- 8
- 25
0
votes
1 answer
How can I specify the version of a reference to Oracle.DataAccess
I have installed 2 versions of ODAC (Oracle Data Access Client), so I can see there're two assemblies in the GAC. Now I am trying to use the old one which is 4.112.2.0, but no matter how I did, the version which is used is always the latest one…
Leo Yao
- 151
- 5
0
votes
1 answer
Exception with .Net ODAC 11g -- >> ora-12514: TNS: listener does not currently know of service requested in connect descriptor
We've got a 32 bit .Net windows application which uses ODAC 10g (1.x) to connect to a 10g database on the backend.
Things work fine in this deployment.
We're in the process of setting up a new development machine.
This machine has ORACLE 11g (64…
JohnB
- 3,921
- 8
- 49
- 99
0
votes
1 answer
Why am I getting a 'System.TypeInitializationException' when I create an Oracle connection in my .Net WCF web service?
I'm currently working on implementing a WCF service which talks to an Oracle 10g database on the backend. When I attempt to connect to the database from within my service, I get the following exception: System.TypeInitializationException.
I'm…
JohnB
- 3,921
- 8
- 49
- 99
0
votes
1 answer
Oracle Custom type parameter
i am new to oracle .I have procedure which has a param like this
@param1 title_type.title_type_code%type
title_type is custom type
ok.. now
How do I pass the parameter from c# using ODAC( OracleParameter object)
%type is confusing do you need to…
0
votes
1 answer
oracle 11g r2 - deploying dbmsclr.plb as sysdba after ODAC installation
I just finished installing ODTwithODAC112012 on my system. Now I am trying to deploy dbmsclr.plb
But I am getting the error SP2-024 nothing to change.
Here is the command window:-
C:\>sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Tue…
Sujit Prabhakaran
- 295
- 3
- 12
- 26
0
votes
2 answers
Entity Framework and inheritance - Possible bug in EF?
I've been trying to get started using entity framework and have ran across a peculiar behavior. I've prepared this short example to demonstrate.
In short, I'm trying to create a table-per-type model, using a base type and an inherited type, "Person"…
Valdemar
- 950
- 1
- 12
- 20
0
votes
1 answer
Can Oracle client versions 9 and 11 both be installed on the same machine?
I have a program using odac(11.2) and oracle client 11.2. Now I want to deploy it to a box which is already installed a oracle 9i client.
Some existing programs is depend on it so I fear the new client will harm the existing program. Is this true? …
user622851
- 177
- 2
- 13
0
votes
1 answer
how to handle concurrency in EF4(ORACLE)
I would like to know how to safely update data when programming with Entity Framework 4(ODAC).
void DescreaseInventory(int id, int qty){
var order = (from o in context.Orders where o.ID ==id select o).FirstOrDefault;
if( order != null ){
if(…
user622851
- 177
- 2
- 13
0
votes
1 answer
Entity Framework with Oracle
I have installed the ODAC 11 and I would like to use it with EF Database First but it doesn't appear in the "Choose Data Source" dialog just the SQL Server providers.
I don't know how to go further.
I need a little help, please.
sada
- 584
- 2
- 8
- 25
0
votes
1 answer
Is it compulsory to restart IIS WebApp when Oracle 11g stored procedure are updated?
I've got an ASP.NET webapp, which uses Oracle 11g stored procedures, through ODAC (Oracle .NET data provider)
I realized that updating the stored procedures seems more than often to break the website, which has to be restarted, so as to work…
Vinzz
- 3,968
- 6
- 36
- 51
-1
votes
0 answers
Web page to display table contents - where to start
I am looking to create a web page which displays data from an oracle table. If it can refresh automatically after every few minutes that will be great. Where do I start to develop .NET/ASP`based solution?
I have setup Visual studio 2022, installed…
srg2023
- 1