Questions tagged [oracle-manageddataaccess]

1

votes
0

answer
41

Views

Stored procedure from Oracle not returning Control to .NET process

I've 1 .NET process developed in C# that uses Oracle.DataAccess Library to connect to our Oracle Database. My process does some massive updates, and after them must call a stored procedure in Oracle to do some stuff. This procedure tooks 1,5 hours to finalize (I can see that it has finished because...
Igor
1

votes
1

answer
431

Views

DDEX provider is not installed for Oracle.DataAccess.Client error

I have WebForms application, that interact with Oracle database using EntityFramework. I can open and view .edmx (data model) file without any error, but when I try to perform action Update model from Database... after changes to the DB I get the following error: I'm using: Oracle 11g 32bit edition,...
Konstantin Chsherbakov
1

votes
0

answer
17

Views

Oracle Managed Data Access - How to configure TNS_ADMIN dynamically in code?

Is there a way to set or change the TNS_ADMIN setting though code? This question was asked here by someone else but not answered. Put settings in code - Oracle Managed Data Access
N_B
1

votes
0

answer
28

Views

Cannot use loaded Oracle.ManagedDataAccess assembly in Powershell

I am trying to connect to an existing oracle database using Powershell and Oracle.ManagedDatabaseAccess.dll. I have the code running in C# using the very same library. The assembly is loaded but i cannot use it. I am using Win10 and Powershell ISE. I also use VS2017/15.3.2 and .Net 4.7.02046. I tri...
Ethan
1

votes
2

answer
43

Views

How do I call Oracle function in c# which takes parameters and return records?

I have an Oracle function, which takes 3 parameters and return records which has four columns. But I am getting an exception which is ORA-06550: line 1, column 7: PLS-00221: 'get_receipts' is not a procedure or is undefined this is my code: OracleConnection con = new OracleConnection(oracleDB); co...
istudent
0

votes
0

answer
5

Views

Oracle Managed Data Reader Returning DBNull for One Database Table

Issue: I am using the Oracle managed data access client to connect to an Oracle eBS database. When selecting a value from one table I get a result; when changing the table I get a null value. Background: In my SQLDeveloper client I can connect to the database and run the following queries: SELECT M...
Jay Tracewell
0

votes
0

answer
22

Views

Call Sql function that returns row/record

Database side I have a simple package that contains a custom datatype GENERIC_API_PKG.DETAILS_ROW and a function GENERIC_API_PKG.GET_DETAILS that accepts a varchar2 parameter and a returns this custom datatype, I have tested its functionality using sql editor and it is working fine as below: Applica...
simsim
5

votes
1

answer
5.3k

Views

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 { EmployeeContext employeeContext = new EmployeeContex...
Ian
6

votes
1

answer
183

Views

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 narrowed down the issue and it seems to be caused...
2

votes
2

answer
1.8k

Views

Read Oracle data connection using Entity Framework in C#

I have Oracle database 11g and I want to use Entity Framework to read data from it. In first step I am trying to establish database connection and get status if it connected. However I am getting following error; An exception of type 'System.ArgumentException' occurred in Oracle.ManagedDataAccess.dl...
toxic
3

votes
1

answer
1.7k

Views

“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 string. If I write the full connection string, with...
André Cristino
2

votes
2

answer
1.1k

Views

EF 6 with ODP.Net Oracle.ManagedDataAccess, How to Use Non-Capital Letter for Class Properties?

I am using the EF 6 with ODP.Net Oracle.ManagedDataAccess for my ASP.Net MVC Web application. I have the following Model called Employee (in Model\Employee.cs file): [Table('TBLEMPLOYEE')] public class Employee { public int Id { get; set; } public string Name { get; set; } public string Gender { get...
Ian
3

votes
1

answer
156

Views

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 a different WHERE-clause. The Oracle database serve...
Housy
7

votes
1

answer
1.9k

Views

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 ,OUTASSETREGISTERED OUT VARCHAR2 ) AS BEGIN SELECT INPROJECTNAME...
Donny
2

votes
1

answer
2.3k

Views

.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 we always install the 'full' Oracle Administrator cl...
Pinzi
2

votes
2

answer
1.9k

Views

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(){ first_name = 'Abe', last_name = 'Lincoln'}; //Do somethin...
Kjensen
7

votes
2

answer
804

Views

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 getSelector() { return m => new { ID = m.ID, NAME = m.Name, LONG...
3per
1

votes
1

answer
1.9k

Views

“No credentials are available in the security package” when connection to Oracle is performed

The tests that performs connection to Oracle database started fail with AuthenticationException after last Windows update. The message and stack trace are provided below: Test method threw exception: System.Data.Entity.Core.EntityException: The underlying provider failed on Open. ---> Oracle.Manage...
Bazaleev Nikolay
2

votes
0

answer
68

Views

Design Time T4 Templates Using Oracle.ManagedDataAccess

I've been trying to convert some projects from using Oracle.DataAccess to Oracle.ManagedDataAccess. I've come across an issue that I can't figure out how to resolve. I've attempted to run on all of these platforms with the same results: Visual Studio 2012, 2015, and 2017 Windows 7 and 10 .NET Frame...
DrewF
2

votes
1

answer
487

Views

Error ora-12550 with oracle.ManagedDataAccess.Client

When i execute my code i have the following error : ORA-12550 : The supplied connect descriptor contains illegal syntax. I checked if i have the correct syntax on http://www.orafaq.com/wiki/Tnsnames.ora and nothing seem bad so i don't know whence can this error. public static OracleConnection GetDB...
Millet Antoine
2

votes
4

answer
8.7k

Views

How to properly close ODP.net connection : dispose() or close()?

this is my powershell code : [void][System.Reflection.Assembly]::LoadFile('C:\DLL\Oracle.ManagedDataAccess.dll') $OracleConnexion = New-Object Oracle.ManagedDataAccess.Client.OracleConnection('User Id=test;Password='test';Data Source=10.2.2.1/TEST') $TimeOut = 60 $OracleConnexion.Open() $Query=$Ora...
Adeel ASIF
7

votes
2

answer
122

Views

Getting Buffer output 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 returning -1, which should be correct based on the do...
Jimenemex
3

votes
1

answer
8.8k

Views

How to Add/Activate “Oracle.ManagedDataAccess.Client” in the EF 6 provider config file?

I am learning to make ASP.Net MVC Web application using VS2013 following these video series. When I got the following error: No Entity Framework provider found for the ADO.NET provider with invariant name 'Oracle.ManagedDataAccess.Client'. Make sure the provider is registered in the 'entityFramework...
Ian
4

votes
0

answer
695

Views

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 without any problem. I cannot use the Model Browser a...
smartwepa
3

votes
0

answer
366

Views

Entity Framework 6 + Oracle “Where In” Clause

Despite our best efforts we have been unable to get Entity Framework (6.1.3) + Oracle Managed Data Access (12.1.2400) to generate an 'IN' clause when using contains in a where statement. For the following query: var x = Tests .Where(t => new[] { 1, 2, 3}.Contains(t.ServiceLegId)); var query = x.ToSt...
PremiumTier
0

votes
2

answer
1.3k

Views

Opening Oracle OleDb connection succeeds, while managed driver connection fails

From C# I'm connecting to Oracle using OleDb doing the following: String connectionString = 'Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=x;Password=y;Data Source=z'; var connection = new System.Data.OleDbConnection(connectionString); connection.Open(); That works fine. From the sa...
Mike W.
2

votes
2

answer
1.9k

Views

How to connect to Oracle DB using TNS alias with Entity Framework 6?

In my setup I have a .NET application built with Visual Studio 2015 trying to access data on an Oracle 12c database using Entity Framework 6. Here's what I did to acchieve that: I followed a tutorial at oracle.com on how to use nuget to install the Official Oracle ODP.NET, Managed Entity Framework D...
Spontifixus