Stack Overflow
Stack Overflow

Questions tagged [odp.net]

Oracle Data Provider for .NET (ODP.NET) features optimized ADO.NET data access to the Oracle database.

Oracle Data Provider for .NET (ODP.NET) features optimized ADO.NET data access to the Oracle database. ODP.NET allows developers to take advantage of advanced Oracle database functionality, including Real Application Clusters, XML DB, and advanced security.

ODP.NET makes using Oracle from .NET more flexible, faster, and more stable. ODP.NET includes many features not available from other .NET drivers, including a native XML data type, self-tuning, RAC-optimized connection pooling, promotable transactions, and Advanced Queuing.

ODP.NET home page for news, downloads and help: http://otn.oracle.com/dotnet

1322 questions
-1
votes
1 answer

How to create a Visual Studio Windows Forms app with connection to Oracle DB portable?

The app connects to the Oracle DB directly, extracts data and makes it into an Excel file. The problem is it works only on the PC on with it was elaborated. Trying to use the project on other PCs throws errors of processor incompatibility, incorrect…
leGato
  • 9
  • 3
-1
votes
1 answer

Is Oracle.ManagedDataAccess pooling per application or per server?

I understand that the connections pools are created from the connectionstring. I run 2 differents applications both using Oracle.ManagedDataAccess and both using the same connectionstring. Do I get 1 pool per application or 1 common to both ?
Vincent
  • 510
  • 1
  • 5
  • 23
-1
votes
3 answers

The provider is not compatible with the version of Oracle client - c#

When I try to browse my project through IIS, I get the below error "The provider is not compatible with the version of Oracle client" Description: An unhandled exception occurred during the execution of the current web request. Please review…
Sahil Sehgal
  • 1
  • 1
-1
votes
1 answer

Does Oracle ManagedDataAccess driver for .net supports all Oracle database releases 12c 18c 19c

I want to confirm that the latest Oracle managedDataAccess driver is supporting Oracle latest database releases. I were not able to find any confirmation from Oracle documentation regarding this matter.
Thorn
  • 1
  • 2
-1
votes
1 answer

How to call Oracle stored procedure which accepts RefCursor as out parameter using Entity Framework

I have an Oracle stored procedure which accepts multiple out parameters of type RefCursor (code below). create or replace PROCEDURE PROCEDURE1( lookupvalues out SYS_REFCURSOR, lookupvalues1 out SYS_REFCURSOR) AS BEGIN open…
user2889674
  • 97
  • 2
  • 12
-1
votes
1 answer

Is there a nicer way of building an OracleCommand?

I'm making an ODP.NET database application for my school project using wpf. I have a list of checkboxes corresponding to table's columns. Is there a nicer way of building a select statement than just going through a foreach loop? I've looked into…
mac501
  • 37
  • 5
-1
votes
1 answer

Does Oracle ODP.NET have a bug dealing with percent symbol in queries?

I'm using C# with oracle ODP.NET to query a table, and it seems to have a odd behavior if the field value has the symbol "%". As the following example: In Oracle (11g or 12c) I run the following command to create a test table inserting the values…
F_Fernando
  • 11
  • 2
-1
votes
4 answers

Find current time between two fields in Oracle

I have a situation where i need to raise an event everyday between 23:00 hrs to next day 01:00 hrs. My table has a data of date which will look like: Start date | EndDate 31-05-2016 23:00:00 | 01-06-2016 01:00:00 Already the database is…
smilu
  • 859
  • 7
  • 30
  • 53
-1
votes
2 answers

VB.NET Oracle SQL "INSERT INTO" with "RETURNING INTO" gives ORA-00933 Command Not Properly Ended

I need to update some code and as part of this I need to insert a row into a table and obtain the id (primary key) of the row just entered. Have researched this and I believe I should be using RETURNING INTO and Oracle Parameters. I have used…
TobyKenobi
  • 1
  • 2
-1
votes
1 answer

Increment column value by one in Oracle - (ORA-01013)

I have the following update statement which works fine in SQL Developer: UPDATE SDUSERS SET PWDATTEMPTS=PWDATTEMPTS+1 WHERE lower(UserName)='test'; Now, in my VB.NET it does not update the database for some reason and it produces error ORA-01013:…
alwaysVBNET
  • 3,150
  • 8
  • 32
  • 65
-1
votes
1 answer

Oracle managed data access TNS no listener

Below is my config file
user2755680
  • 85
  • 11
-1
votes
3 answers

How can the same decimal have different bits and be formatted differently by ToString()?

In our Oracle database, I have a table (say MYTABLE) with column VALUE_NUMBER of type NUMBER (NULL, no precision specified). This table contains a value 1178.2 When retrieving data from this column using standard ADO.Net (actually ODP.Net) and then…
jeroenh
  • 26,362
  • 10
  • 73
  • 104
-1
votes
1 answer

How to do the equivalent of SELECT .. FRO UPDATE in a SOA architecture?

The title is probably not be explicit enough, so let me try to explain. I'm working on a new project, built on .NET, it consists of WPF clients that use WCF web services to access an Oracle database. The problem is not this basic architecture, but…
madd0
  • 9,053
  • 3
  • 35
  • 62
-2
votes
1 answer

How to Retrieve an Oracle Sequence value?

I need to retrieve a VarChar sequence value. How is that done using C# and Oracle's ODP components? A less-specific answer might help, too (e.g., how it's done in VB or how it's done using a different component set).
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
-2
votes
1 answer

Adding data using C# WPF

My goal is to add data to Oracle database. I've tried the tutorial at this link(https://youtu.be/LUKp76CNmJY) which is helpful for beginner. But the INSERT does not work(DELETE also does not work). However UPDATE works. Typical HR account is used.…
Soon
  • 491
  • 3
  • 16
1 2 3
…
88
89