Stack Overflow
Stack Overflow

Questions tagged [oracle-manageddataaccess]

The Oracle.ManagedDataAccess is a data access namespace in ODP.Net which is used in contrast with Oracle.DataAccess.

The Oracle.ManagedDataAccess is a data access namespace in ODP.Net. It is used in contrast with Oracle.DataAccess which of unmanaged data access.

See of their differences can be found in here. And the discussion for their performance differences can be found in this SO post. And to learn more of it, please watch this.

135 questions
22
votes
1 answer

Entity Framework Core - Take(1), Single(), First()... Not Working with Oracle Provider (ORA-00933: SQL command not properly ended)

I'm using ef core(2.2.4) with oracle database oracleProvider: Oracle.EntityFrameworkCore(2.18.0-beta3) this code: IQueryable queryable = context .KeyInfos .Where(x => x.MobileNumber == "989191111111") …
Mojtaba Khooryani
  • 1,763
  • 1
  • 17
  • 36
11
votes
4 answers

Getting output buffer from DBMS_OUTPUT.GET_LINES in C#

I'm trying to get the output from the DBMS_OUTPUT.PUT_LINE() method in my anonymous PL/SQL block through C#. I've looked at a couple of other related questions here, but am still having trouble. The return code of executing the anonymous block is…
Jimenemex
  • 3,104
  • 3
  • 24
  • 56
10
votes
3 answers

Table Does Not Exist while using EF 6 and Oracle.ManagedDataAccess

I am creating a MVC application using EF 6.0.0.0 and ODP.Net Oracle.ManagedDataAccess version 4.121.2.0 for the data access. In my Controller called EmployeeController, I have the following code snippet: public ActionResult Details(int id) { try…
Ian
  • 30,182
  • 19
  • 69
  • 107
9
votes
2 answers

Calling Oracle stored procedure using Entity Framework with output parameter?

I have a simple Oracle stored procedure that gets three parameters passed in, and has one output parameter: CREATE OR REPLACE PROCEDURE RA.RA_REGISTERASSET ( INPROJECTNAME IN VARCHAR2 ,INCOUNTRYCODE IN VARCHAR2 ,INLOCATION IN VARCHAR2 …
Donald N. Mafa
  • 5,131
  • 10
  • 39
  • 56
8
votes
3 answers

Error (ORA-21700) with Table Operator after updating to Oracle 12.2 from 12.1

Our Oracle database was recently updated from 12.1.0.2 to 12.2.0.1 + patch set update 20180417. Ever since the update we are getting the following error when calling a plsql procedure: ORA-21700: object does not exist or is marked for delete We have…
Aaron at ElevenWinds
  • 81
  • 3
8
votes
2 answers

Entity Framework ORA-00932: inconsistent datatypes: “'expected CLOB got CHAR”

Oracle.ManagedDataAccess.EntityFramework 6.122.1.0 library is used to access to an Oracle Database from MVC ASP.Net application. It is the latest library version from the NuGet as of November, 14th 2017 protected override Expression
3per
  • 351
  • 9
  • 26
5
votes
1 answer

"ORA-00933: SQL command not properly ended" using Oracle.ManagedDataAccess

I'm getting what I can only describe as the oracle.ManagedDataAccess package from nuget seeming to add characters onto the end of my query. My ultimate goal is to supply bind variables to the below SQL in the form of command parameters from C#. My…
user544141
  • 90
  • 1
  • 6
4
votes
1 answer

Oracle.ManagedDataAccess TNS_ADMIN in Web.Config

I am trying to configure my solution that is using the Oracle.ManagedDataAccess library to use TNS names in the connection strings instead of explicit data sources. Before any changes the program is working correctly, but all of my attempts to…
Evan Frisch
  • 1,334
  • 5
  • 22
  • 40
4
votes
4 answers

How to insert identity value in Oracle using Entity Framework using a sequence

In an Oracle database, that has an ID column defined as a number: ...and a corresponding sequence for the table...: How do I make sure the ID column gets the next value in the sequence? using (var db = new MyOracleDb()){ var user= new User(){…
Kjensen
  • 12,447
  • 36
  • 109
  • 171
4
votes
1 answer

"the provider did not return a providermanifesttoken" using Oracle MangedDataAccess with EF 6 Code First

I have an web application that was using oracle 11g, EF 5 code first and system.data.oracleclient. So now, It was upgraded to EF 6 and Oracle Managed Data Access. The ODP .Net is installed. This error happens only when I am using TNS in connection…
André Cristino
  • 95
  • 1
  • 14
4
votes
1 answer

Entity Framework with Oracle.ManagedDataAccess: Error 175 in EDMX File

I use Entity Framework 5 together with Oracle.ManagedDataAccess. Visual Studio says there is a error in my edmx file: Error 175: The specified store provider cannot be found in the configuration, or is not valid. My Application compiles and runs…
smartwepa
  • 311
  • 1
  • 3
  • 11
3
votes
1 answer

ONSException Exception - no nodes configured

When opening an Oracle Connection, I see a few Exceptions in output window. Exception occurred: "OracleInternal.NotificationServices.ONSException" in Oracle.ManagedDataAccess.dll I updated the Oracle Management Driver to the latest Version, but…
Lord_Pinhead
  • 127
  • 1
  • 10
3
votes
2 answers

Oracle change notification contains invalid actions

Setup I've created a Console application targeting .NET 4.7.2 and installed the NuGet package Oracle.ManagedDataAccess version 12.2.1100 (latest/current) that sets up a dependency with 2 queries to monitor changes made to MYTABLE, both queries have…
huysentruitw
  • 27,376
  • 9
  • 90
  • 133
3
votes
0 answers

Pass an array of object to Stored procedure with Oracle ManagedDataAccess.dll

I am upgrading my application to Oracle.ManagedDataAccess. I want to pass an array of objects to a stored procedure. Following is my SP: CREATE OR REPLACE TYPE MATCHING_CRITERIA_LIST IS TABLE OF CRITERIA; CREATE OR REPLACE PROCEDURE…
shruti singh
  • 146
  • 11
3
votes
1 answer

.NET 4.6 Oracle.ManagedDataAccess Requirements

What exactly is the minimum requirement to get a .NET 4.6 application working with Oracle? We are already using the Oracle.ManagedDataAccess client. We are using the Entity Framework and also DataSets (TableAdapters,...) for data access. Currently…
Pinzi
  • 293
  • 6
  • 18
1
2 3
…
8 9