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
0
votes
1 answer

Can we use System.Data.OracleClient for sending a List<> to the Oracle stored procedure?

I have a requirement to send couple of List<> objects to the Oracle store procedure. I can do it using ODP. But I just want to confirm that can it be possible with the System.Data.OracleClient.
Amit
  • 623
  • 2
  • 8
  • 18
0
votes
1 answer

ODP.NET not recognized procedure in oracle package

I have a simple package defined as follows: CREATE OR REPLACE PACKAGE wvParty IS TYPE refParties IS REF CURSOR; END wvParty; CREATE OR REPLACE PACKAGE BODY wvParty IS PROCEDURE proc_GetParties( p_party_name IN OUT VARCHAR2, …
George Hutto
  • 1
  • 3
0
votes
1 answer

Poor performance with ODP.net parameter array inserts when record contains BLOBs

I use ODP.net parameter arrays to achieve batch insert of records. This way performs very well when the records don't contain BLOB column - typically about 10,000 records can be inserted in one second. If a record contains BLOB column, it has a poor…
seacat
  • 23
  • 5
0
votes
1 answer

Oracle ArrayBound Stored Procedure fails only with specific field

I have a stored procedure that works and has been working for months for inserting data. Here's the "short" version: procedure saveApplication( in_confirmation_number varchar2 := null …
user158017
  • 2,891
  • 30
  • 37
0
votes
1 answer

Oracle.DataAccess dll for .Net application

I have a C# console application that runs on a 64 bit Windows 2008 server and access Oracle 11g via ODP.net. It's been working for about 6 months. I compile the program on my computer, making the build setting "Any CPU". I installed the…
user158017
  • 2,891
  • 30
  • 37
0
votes
0 answers

Using Entity Framework 5 with overloaded Oracle stored procedures

I have the following question. I have a couple of stored procedures in an Oracle database package. As it is, they differ in the number of parameters (I'm not allowed to touch or change the stored procedures). I was using ODP.NET and Entity Framework…
Heathcliff
  • 3,048
  • 4
  • 25
  • 44
0
votes
1 answer

Load operation failed after selecting a new table - works again after unselect

I am currently facing a really strange problem with Visual Studio LightSwitch 2010 in combination with an Oracle Database and ODP.NET. So far I have added all the necessary tables to the LightSwitch application and also created the screens for all…
Daniel W.
  • 449
  • 10
  • 29
0
votes
1 answer

Can Oracle Ref Cursors only be used with Procedures and Functions?

Can Oracle Ref Cursors only be used with Procedures and Functions, or can they also be used with PL/SQL issued via an ODP.NET OracleCommand object (contained as a string in the CommandText property)?
Paul
  • 387
  • 1
  • 6
  • 11
0
votes
1 answer

EntLibContrib and OdpNet

I'm trying to get a ref cursor returned from a oracle procedure back to my .Net app, but I keep getting an error regarding the wrong number of parameters. The oracle procedure has the following params: PROCEDURE sp_user_list(pv_username IN…
Martin
  • 587
  • 1
  • 6
  • 18
0
votes
3 answers

Perform operations on a database using a DataSet without caching

I'm very sorry if this is going to be a bad question. I've done very little database programming. This might be the time to read up on it from scratch, which I will probably do at some point, but I'm pressed for time right now. Is there a way I can…
GregRos
  • 8,667
  • 3
  • 37
  • 63
0
votes
2 answers

Oracle Command not returning desired results

I am new at working with Oracle on .NET. I have worked with SQL in the past and have not encountered this problem. I have a Oracle server to which I connect with this connection string:
schumitza
  • 65
  • 7
0
votes
1 answer

ODP.Net - Oracle NUMBER(11,6) column is a System.Double in the data table

Ran into an issue recently - We encounter an exception when we are trying to set a value in our data table. The exception is System.ArgumentException: Input string was not in a correct format.Couldn't store <42.356> in COLUMN_NAME Column. Expected…
Siddharth Kumar
  • 309
  • 4
  • 17
0
votes
2 answers

ODP.NET UPDATE... RETURNING INTO... multiple rows, Parameter type

i was wondering if the following scheme of action is possible: i am implementing a simple data entry application. each editable record resides in a table. the user has to edit multiple records at the same time (to reduce data entry time). what i try…
hello_earth
  • 1,442
  • 1
  • 25
  • 39
0
votes
1 answer

Is it compulsory to restart IIS WebApp when Oracle 11g stored procedure are updated?

I've got an ASP.NET webapp, which uses Oracle 11g stored procedures, through ODAC (Oracle .NET data provider) I realized that updating the stored procedures seems more than often to break the website, which has to be restarted, so as to work…
Vinzz
  • 3,968
  • 6
  • 36
  • 51
-1
votes
1 answer

From within .NET (ODP.NET) how can I access an oracle parameter by name?

Using ODP & VB.NET, I create insert statements with parameters, similar to the following code: Dim objOracleParameter As OracleParameter Dim objCommand As New OracleCommand objOracleParameter = New OracleParameter objOracleParameter.ParameterName =…
Paul Stearns
  • 856
  • 9
  • 30
1 2 3
…
88 89