The Oracle Managed DataAccess Provider is the .Net Native version of ODP.Net. It doesn't need a prior Oracle Client installation or have any dependency on the OCI library. Applications that reference it may therefore be built 'AnyCPU'.
Questions tagged [odp.net-managed]
110 questions
0
votes
0 answers
OracleDataReader not being iterated despite having rows
I'm using Oracle.ManagedDataAccess 19.6.0 to get some data from Oracle 11g 11.2.0.3.0
This code was working fine until yesterday. 223 rows are getting returned by Oracle. But the while (orclDataReader.Read()) is being skipped, as if there are no…
joym8
- 4,014
- 3
- 50
- 93
0
votes
1 answer
Oracle.ManagedDataAccess.Core (Odp.Net Core) User Defined Type and Associative Array Type
I want pass a user defined type or associative array with type to a store procedure in dotnet core with Oracle.ManagedDataAccess.Core (Odp.Net Core). But I can't find any clear example.
Has Odp.net Core support User Defined Type or Associative Array…
O. Emre Erkmen
- 3
- 3
0
votes
0 answers
executing an oracle sql statement with a refcursor causes large execution time
I'm currently attempting to get a count of rows from a couple of tables. When I run it directly, it executes and returns in a couple of milliseconds. However, when I try to execute the same query with a refcursor return type, it is taking over a…
Steven Yoo
- 53
- 6
0
votes
1 answer
Using EntityFramework for ODP.NET, why does the following raw SQL command hang on Oracle 12c?
I'm using
Visual Studio 2015
Oracle.ManagedDataAccess 18.3.0
Oracle.ManagedDataAccess.EntityFramework 18.3.0
Entity Framework 6.2.0
In a test project. The following EF based raw SQL command executes on Oracle 11g Express Edition, but fails (more…
Mike Atkisson
- 581
- 4
- 9
0
votes
0 answers
Oracle database in data source as {e5e86-......}
Data Source Check this image. Instead of oracle database i am getting {......} this variables. why so ? Thanks in advance.
Aakash
- 13
- 2
0
votes
1 answer
Issue with executing stored procedure with an OUT refcursor when using ODP.Net managed with Enterprise library
I am trying to execute multiple (3) stored procedures one by one using managed ODP.Net with Enterprise Library. Each stored procedure returns an OUT cursor, each of which has been named "cur_out". What is weird is that the first stored procedure…
Hitesh
- 11
- 3
0
votes
1 answer
How to query data from synonyms using odp.net managed driver in c#?
I have a connexion to a service in which I only have access to synonyms (i.e., I cannot create any view, procedure, ...) and I intent to query data from them. I'm using ODP.NET managed driver to do so but until now I found nothing to achieve that.…
dcg
- 4,187
- 1
- 18
- 32
0
votes
1 answer
In Entity Framework, how to generate entities from different Oracle schemas in VS2017
I am currently attempting to generate code from tables from an existing Oracle 12 database from within Entity Framework 6. The problem I am having is that while it is able to see the schema that I own when I log into the environment, Entity…
tone
- 1,374
- 20
- 47
0
votes
1 answer
Failing over on Multiple IP Address
Developed an application on the client side that accesses an oracle 12c database server using ODP.NET. I have 2 network adapters on both client and the server. The server is listening on both network rails on different ports.
If I pull a network…
dave
- 13
- 2
0
votes
1 answer
Oracle Stored procedure return cursor slow to C#, fast on TOAD
We are using asp.net mvc as web application and oracle 12C as database, 'Oracle.DataAccess.Client'(12.1.0, 64 bit version) for connecting to Oracle Database, and our asp.net MVC application runs on 64 bit machine as well.
One of our stored…
venu
- 147
- 3
- 15
0
votes
1 answer
How to add configuration options to ODP.Net Managed Driver in Powershell
Using Oracle Managed Data Provider ODP.NET from Powershell works great. However, how to add application specific configuration settings is not quite clear.
How can this be done?
Niels Jespersen
- 410
- 4
- 16
0
votes
1 answer
Managed Oracle access, support for "≤"
We have switched from unmanaged to managed Oracle in our Winform application and everything is working fine except for one detail. If I save the string "≤" to the database and then try to retrieve it again I get "=" back. It is stored as an nvarchar…
Martin
- 1
- 1
0
votes
1 answer
C# ODB.NET Out parameter is always DBNull
I have a stored procedure within a package in Oracle SQL Server.
This procedure has input and output parameters. The procedure itself works and when executed in Oracle SQL Developer the output parameter reads the expected output (column value of…
Devvox93
- 166
- 1
- 3
- 14
0
votes
1 answer
C# : Getting error ORA-06550 while updating BLOB using stored procedure & ODP.NET
ORA-06550: line 1, column 7: PLS-00306: wrong number or types of
arguments in call to 'UPDATEPHOTO'
ORA-06550: line 1, column 7: PL/SQL: Statement
ignoredOracle.ManagedDataAccess.Client.OracleException
I don't know what is wrong either with…
Rex Jones
- 99
- 3
- 14
0
votes
0 answers
ORA-12570: Network Session - after running 20 odd minutes
We are getting network session error.
"ORA-12570: Network Session: Unexpected packet read error".
This comes after running queries 20-21 minutes. Its consistently throwing this error in all cases if I run a single query or multiple queries.
Till…
Mohan J
- 1
- 2