Stack Overflow
Stack Overflow

Questions tagged [odp.net-managed]

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'.

110 questions
1
vote
1 answer

How to safely create a connection with oracle and asp.net core?

With ASP.NET Core 2.2, Dapper Oracle 1.0.1 and managed Oracle ODP drivers 2.19.50 Using the following code to issue a simple read query. The code below is being called maybe ~10 times a minute by different API consumers. // connectionString = Data…
O.O
  • 11,077
  • 18
  • 94
  • 182
1
vote
1 answer

ora-01017 with ODP.net and NTS as sysdba

I'm having trouble connecting to my oracle databases with NTS and ODP as sysdba (the goal is to use a lot of maintenance scripts without any passwords in it). I did some research without success, so here I come. Here is the powershell code I use…
Gael Piveteau
  • 11
  • 3
1
vote
2 answers

Reduce PARSE_CALLS using Oracle ODP.NET (or reuse cursors)

When I run Queries from ODP.NET I see in V$SQL that for every call it performs a PARSE_CALL. See: select s.FETCHES,s.PARSE_CALLS,s.sql_Text,s.sql_id from v$sql s where sql_Text = 'select 1 from dual /*test2*/' Returns: Even though I…
Noam
  • 4,472
  • 5
  • 30
  • 47
1
vote
0 answers

ODP.NET not picking up on .net alias

I'm working on a new mvc web app and I'm trying to configure a connection to an oracle database. I've installed Oracle.ManagedDataAccess and Oracle.ManagedDataAccess.EntityFramework packages. I've updated the connection string and datasources in my…
Greg B
  • 803
  • 9
  • 22
1
vote
0 answers

OracleManagedDataAccess - Connection Request Timeout even when using Semaphore

I have a process that basically updates ~30,000 rows of a single Oracle table. I do this concurrently in Sempahore restricted batches of 20 at a time. I currently have my OracleManagedDataAccess connection pool set to 20 min pool size and 200 max…
Hendel
  • 53
  • 5
1
vote
1 answer

ODP.net - ORA-12537 End of File errors when calling stored procedure

I'm perplexed by the above, which keeps cropping up intermittently whenever I execute a stored proc within a package on our new Oracle installation. The sproc is called from WCF, which returns the following exception :
PoorbandTony
  • 380
  • 3
  • 12
1
vote
0 answers

Can ODP.NET pass a boolean parameter type to stored procedure?

I am using ODP.NET 12.1.2400 and EF6 with an Oracle 11 database. I have an Oracle stored procedure that has a parameter of type BOOLEAN. I have imported this stored procedure and added the function import to my EF data model. However I get a runtime…
Dave
  • 329
  • 2
  • 6
  • 17
1
vote
0 answers

How to make Oracle return an error when i give it invalid SQL?

I've been using the Oracle ODP.NET, Managed Driver to issue queries from C#. There were many queries i wrote that took forever to return any data; like it was ignoring my row limiting clauses: SELECT TOP 10 * FROM Customers or SELECT * FROM…
Ian Boyd
  • 246,734
  • 253
  • 869
  • 1,219
1
vote
0 answers

Why doesn't OracleDataAdapter.Fill work with this Natural Join SQL Statement

I am having trouble getting certain SQL statements containing Natural Joins to work with OracleDataAdapter.Fill(). I am using Oracle.ManagedDataAccess 4.121.1.0. To illustrate this, review the following valid SQL statements. All work properly in a…
Kent Anderson
  • 486
  • 2
  • 16
1
vote
1 answer

How to prevent overflow while reading oracle FLOAT(126) with many digits after the decimal to ADO.NET DataTable?

When a database column contains number like 0.11212121212121356500008888888888874343468766, it can't be fit to DataRow's generated Decimal-type column. This same applies to DataReader. With DataReader I have solved this with wrapper: public class…
char m
  • 7,840
  • 14
  • 68
  • 117
1
vote
1 answer

Is this a bug in the Oracle ODP.NET

I'm curious if this is a bug in the Oracle ODP.NET provider. I created a parameterized insert statement. I named one of the parameters ':EMPNO' and when testing it gave it a value of '8000'. In the database the EMPNO column was defined as…
user3245753
  • 13
  • 2
1
vote
1 answer

Managed ODP.net: change notification and ldap

I'm using the LDAP resolution to connect to an Oracle database. This works fine now for regular queries, I can open a connection and execute commands against it. Unfortunately, it does not work for change notification queries for which I get a…
vc 74
  • 37,131
  • 7
  • 73
  • 89
1
vote
3 answers

Passing Record type from Managed ODP.NET to Oracle Procedure

If I have a record defined in a PL/SQL package and a procedure defined in the same package, is it possible to create the "record" type on the .NET (C#) side and pass it to the procedure using the type t_my_rec. I'm sure I can do this using UDTs…
Jeffrey Kevin Pry
  • 3,266
  • 3
  • 35
  • 67
1
vote
1 answer

Oracle ODP.net Managed driver can't find the Oracle.Web

I've been using oracle unmanaged driver and now I'm just trying to use Oracle ODP.net Managed driver for my web api 2 application. I installed it using PM> Install-Package odp.net.managed Then made "Oracle.ManagedDataAccess" Local copy…
Hello World
  • 328
  • 4
  • 12
1
vote
1 answer

ODP.NET Managed tnsnames.ora IFILE references

Does Managed ODP.NET x64 12.1.0.2 tnsname.ora support using IFILE?? I cannot get it to work. For example, with the normal "thick client" unmanaged Oracle client that I have had installed for years, I used to have my tnsnames.ora file with one line…
BateTech
  • 5,780
  • 3
  • 20
  • 31
1 2 3
4
5 6 7 8