Questions tagged [odac]

1

votes
0

answer
98

Views

Oracle ODAC x64 bit issue with Append_values hint batch error mode not supported for this operation

I am using x64 bit ODAC to connect to oracle 11g from .net webservice. Code fails with: 'error :ora-38910: batch mode not supported for this operation' when executing query with append_values hint. Is this hint supported by x64 bit oracle client , version 2.112.1.0. The x86 bit oracle client for sam...
pjl
1

votes
1

answer
731

Views

Oracle.DataAccess.client deployment not working

I'm deploying an application that uses an oracle provider with Oracle.DataAccess.dll in a machine that already has a specific version of ODAC 64-bit ODAC 11.2. But the application I want to deploy uses a more recent version of ODAC 64-bit ODAC 12.2c. And in the root of that project I have the provid...
cheikh ndiaye
1

votes
1

answer
59

Views

ODAC Field 'column_name' not found in query columns without alias or table name

Recently we've upgraded our ODAC(Oracle Data Access Components) to version 10.1.5. We started to notice a weird problem. When you execute a query, without specifying the table's name or alias it results in the following error: 'Field column_name not found'. Example of working code: select principali...
CS Matheus
1

votes
0

answer
101

Views

Oracle Database Project for Visual Studio 2017 - wrong table creation order when foreign keys are present

With Visual Studio 2017, started an Oracle Database Project (version 2) from scratch, and added two new tables, 'Parent' and Child': Database project Parent.sql contains: CREATE TABLE BDT.Parent ( ID INT NOT NULL, Description VARCHAR2(255) NOT NULL ); Child.sql contains: CREATE TABLE BDT.Child ( I...
andrespa
1

votes
2

answer
1.1k

Views

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 following code. var threemonthsold = DateTime.Now.AddMonths...
coolcake
1

votes
1

answer
617

Views

How can i execute a Oracle Function in C#

I want to execute oracle function from c#. I use oracle data access OracleConnection and OracleCommand. My function is; create or replace FUNCTION Fnc_Sistem(Tbl VarChar2) RETURN Number IS Sistem Number := -1; C Integer; S Integer; BEGIN C := Dbms_sql.open_cursor; Dbms_sql.p...
CocLn
1

votes
1

answer
4.5k

Views

connect with oracle database through visual studio 2010

I have installed oracle database 11gR2 and visual studio 2010 32 bit. Then I tried to install odac for oracle client 11.2.0.1.2. It gives this error. 'Oracle Data Access Components for oracle client 11.2.0.1.1 can only be installed over and existing Oracle client 11.2 Hoeme. Use Oracle Data Access C...
shehani malika
1

votes
1

answer
729

Views

Oracle query multiple delete statements from .NET

I've got issue with executing simple query in Oracle from .NET (ODP): const string sql = @' delete from CLIENTS where CAMPAIGN_ID = :campaignId delete from OPERATORS where CAMPAIGN_ID = :campaignId delete from CAMPAIGNS_EXCLUDE_DAYS where CAMPAIGN_ID = :campaignId delete from CAMPAIGNS where ID = :c...
Andrei
1

votes
2

answer
220

Views

How can I configure an “INDEPENDENT” .NET application with DB Connection to Oracle?

I have a WebService developed in .NET which connects to an Oracle Database. To do that I use the ODAC which Oracle Provides. But every time I need to install my application on the Client Machines, I have so much trouble regarding the 'Oracle Client', depending on if he already has an Oracle Client i...
Laggel
1

votes
1

answer
742

Views

System.Runtime.InteropServices.ExternalException on calling Oracle.DataAccess.Client.OracleConnection.Open()

I have following code to connect to a database using ODP.net: // connection information removed to protect sensitive information string host = '******'; string sid = '*****'; string connectDescriptor = string.Format('(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST={0})(PORT=1521))(CONNECT_DATA=(SID={1})))...
sampathsris
1

votes
1

answer
1.1k

Views

Delphi ADO - how to set default dataset column type without designer

Using Delphi 2007. We do not use the designer to configure our DataSet. It is built automatically from the SQL query. So we need a solution where the fields are built at runtime. I need to SELECT a large number (e.g. 2305843009213693951) from a NUMBER(19,0) column in Oracle using ADO. Our query wor...
wayju
1

votes
1

answer
857

Views

Error while installing Oracle Data Access Components for .Net

I am trying to install 64 bit Oracle Data Access Components (12.1.0.2.1) for .Net. While installation i am getting the error in Prerequisite checks. In prerequisite check it check for Free space, Architecture and Environment variable Path. For architecture parameter, error is System Architecture Co...
manojkulkarni30
1

votes
3

answer
1.1k

Views

ODAC: Object reference not set to an instance of an object

I am trying to connect to Oracle Express 11g. I am using ODAC 12c with Visual Studio 2015. Here's how I am trying to connect: OracleConnection con; con = new OracleConnection('User Id=SYSTEM;Password=manager;Data Source=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.1.22)(PORT = 1521)) (CONN...
Nikita Zernov
1

votes
1

answer
362

Views

Using different version of ODAC to connect to Oracle

Currently I'm working on a project where we just recently upgraded our version of Oracle from 11g to 12c on our testing server, as well as my local development setup. After the upgrade on my local setup, I upgraded my ODAC (primarily for Oracle.DataAccess.dll) to use the 12c 32-bit version. It took...
IyaTaisho
1

votes
1

answer
554

Views

(ORA-12154) Unable to connect to data source in tnsnames.ora from migrated SSIS project in VS 2017

I have a directive to pull code off of an old server and move it to my workstation, and also to update all TFS connections to our new TFS 2017 setup. I found a very important SSIS project that was only maintained by the person I replaced; it was still in VS BIDS 2008, and therefore can't connect to...
CDove
1

votes
1

answer
0

Views

Oracle Data Access components 64 bit not working in IIS express 7.5

I have installed ODAC (Oracle data Access Components 64 bit) odp.net 4. But unfortunately it does not work with IIs Express. IIS express documentation says it supports both 32bit and 64bit systems. Is it possible that it can work with odp.net 4 (64 bit), or must we work with odac 32 bit components...
iknowitwasyoufredo
1

votes
1

answer
59

Views

Entity model wizard lack of table documentation

I am using ODAC 11.2 r4 to create an entity model in visual studio 2010. Right now I am testing out what all the wizard will auto generate off my oracle database and I would like to figure out how to generate documentation based off the database. I have set comments to both my table and columns, but...
Justin
1

votes
2

answer
895

Views

ODAC seems to be caching table schema?

I'm using Oracle's ODAC.NET for a .NET 3.5 project against an Oracle 11 Express database, and I'm seeing behavior that I can't explain (and can't seem to work around). ODAC should be the latest, I just pulled it 3 days ago, but the versions are as follows: Oracle.DataAccess.dll version 2.112.3.0 (re...
ctacke
1

votes
1

answer
2k

Views

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 minimal example that will reproduce the error: // Firs...
Jay Sullivan
1

votes
1

answer
8.8k

Views

odac 11.2.0.4 xcopy install and connect to database in vs2012

I had oracle 11.2.0.3 x32 that have odac with universal installer. After installing odac I could see oracle provider in Visual Studio 2012 Connect to Database window. Now with oracle 11.2.0.4 x64 after installing odac 64-bit ODAC 11.2 Release 5 (11.2.0.3.20) Xcopy for Windows (http://www.oracle.com/...
Lavandil
1

votes
2

answer
2.7k

Views

Adding oracle database as ADO.NET model to visual studio

I was following this guide: http://download.oracle.com/oll/obe/EntityFrameworkOBE/EntityFrameworkOBE.htm I have visual studio 2012, external oracle database, Oracle Data Access Components (ODAC). Now I am trying to add my database, and it asks me first to make a connection, but do not have a spot wh...
Jaanus
1

votes
1

answer
1.4k

Views

Oracle client , Instant client and ODAC [closed]

I want to download the full oracle client 11.2.0.4, but the only download I found in oracle website is Oracle Instant client. Can I get a direct link to the download in Oracle website ? Another thing, I need also the ODAC for .Net, does it include in the Oracle Client ? Or would I need to download i...
Yogev
1

votes
1

answer
1.9k

Views

Oracle Driver Connection with NHibernate in Windows Server x64

I'm working in a Windows Server 2008 R2 Enterprise x64 with C# Windows Form Application, to connect in a Oracle 11g Database with NHibernate. I used the followed NHibernate configuration: string connectionProvider = 'NHibernate.Connection.DriverConnectionProvider'; string dialect = 'NHibernate.Diale...
Jeferson Preti
1

votes
1

answer
90

Views

Error with ODAC provider with SQL that runs OK in MSDAORA

If I execute the following SQL on MSDAORA OleDB Provider, it runs OK. BEGIN MY_PACKAGE_NAME.MY_PROCEDURE_NAME('value1', 'value2'); EXECUTE IMMEDIATE 'CREATE TABLE MY_TABLE_NAME as select MY_ID ID, MY_NAME NAME from MY_OTHER_TABLE'; END; But I'm changing it for Oracle.DataAccess.dll for other reasons...
lmcarreiro
1

votes
2

answer
1.3k

Views

define database schema name universally in entity framework 4.1

i know you can define the entity's schema name per class by using ToTable('TableName', 'SchemaName') but is there a way to set it up so you can set the schema name for all tables in the configuration as i am getting some weird results when i am using some types of relationship mapping and split ent...
Chris McGrath
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
725

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.9k

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
27.4k

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

View additional questions