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
6
votes
2 answers

Entity Framework Ignore Schema

I am using Entity Framework 6 Code First to connect to an oracle database. EF is using "dbo" as the schema. I would rather not specify the schema, but rather let Oracle resolve the schema from the connection string. Is there a way to omit "dbo" or…
Cirem
  • 840
  • 1
  • 11
  • 15
6
votes
1 answer

C# 2010, ODP.net, call stored procedure passing array

I have a PL/SQL stored procedure that takes 4 inputs. One of those inputs is an associative array (Oracle Type: Table of VARCHAR2(1) index by PLS_INTEGER). I want to have a C# program that calls this stored procedure with the proper inputs…
user2316634
  • 81
  • 1
  • 1
  • 3
6
votes
2 answers

oracle odp.net SafeMapping conversion if timestamp with timezone - how to get offset instead of zone name

From c#, using odp.net, I call an oracle function that returns a cursor. Some of the columns are of type "timestamp with time zone" (TSTZ). If I directly use an OracleDataAdapter, those columns are converted to System.DateTime and the timezone…
Ben Schwehn
  • 4,505
  • 1
  • 27
  • 45
6
votes
2 answers

How to pass a table-valued parameter from C# to Oracle stored procedure

I have an Oracle stored procedure named CREATE_CASE_EXL: PROCEDURE CREATE_CASE_EXL(P_RICdata RICTab, P_sACTION_TYPE IN VARCHAR2); where RICTab is a custom type: TYPE RICTab IS TABLE OF MMSRRicRec INDEX BY…
Evgeniy O
  • 143
  • 1
  • 2
  • 8
6
votes
4 answers

ODP.NET and ClickOnce possible?

We have a sqlserver (WinForms) application that is deployed with ClickOnce that talks directly to the database. If we are forced to port it to oracle, can ODP.NET be used with ClickOnce. (The users may not have admin rights on their…
Ian Ringrose
  • 51,220
  • 55
  • 213
  • 317
6
votes
5 answers

ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments

I have problem with calling store procedure on Oracle 11g server. stored procedure PROCEDURE get_rit_by_user_id(KDC_KEY IN VARCHAR2, p_id_utente IN NUMBER, p_cur_out OUT type_cursor)…
Rocco Jr.
  • 77
  • 1
  • 2
  • 10
6
votes
3 answers

Operation is not valid due to the current state of the object

I'm using Entity Framework with ODP.NET 11.2.0.3.0. I got persistence working for some tables, but this one flat out refuses to add a simple new object and I can't quite figure it out. Your help is greatly appreciated. Thank you Here is the code.…
user1198049
  • 491
  • 5
  • 15
5
votes
1 answer

Access Violations with ODP.net under Medium Trust

Environment: Windows Server 2008 R2 IIS 7.5 .NET 4.0, Integrated Application Pool Oracle Client 11.2.0.2.0 ODP.net 11.2.0.2.3 I have a website that uses ODP.net to connect to our Oracle database, and under "Full Trust", the application works…
Zach Green
  • 3,421
  • 4
  • 29
  • 32
5
votes
1 answer

Poor performance getting clob field from Oracle in .Net

I am trying to read a clob column from oracle in .Net and observing very poor performance and lots of network traffic. I have tried ODP+OCI, devArt+OCI ways to access the data with the same results - it takes around 20 seconds to get 1000 rows in a…
neonknight
  • 121
  • 2
  • 5
5
votes
4 answers

Converting a string to an integer in oracle

I am trying to parse a column of strings in Oracle (version 8i) to an integer. I am accessing the results through Oracle.DataAccess library I'm already using TO_NUMBER with a mask to convert the string into a number with no decimal places. The…
JDunkerley
  • 12,355
  • 5
  • 41
  • 45
5
votes
2 answers

why I get OracleTruncateException with ODP.NET OracleDataAdapter but not with System.Data.OracleClient's adapter when DbDataAdapter.Update called?

I do the following: protected int CreateComponent(DbConnection cnctn, string tableName) { int newId; DbCommand selectCmd = _provFactory.CreateCommand(); selectCmd.Connection = cnctn; selectCmd.CommandText = string.Format( …
char m
  • 7,840
  • 14
  • 68
  • 117
5
votes
1 answer

ODP.NET - deploy without installation ORACLE CLIENT - big size of oraociei11.dll

I use ODP.NET in my WPF app for access to Oracle 10g db. I dont want instal oracle client on users computers so I copied these dll to realese…
user572844
5
votes
1 answer

Could not load file or assembly 'Oracle.DataAccess, Version=2.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies

After deploying asp.net app to the server im getting this error. Could not load file or assembly 'Oracle.DataAccess, Version=2.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file…
praveenb
  • 10,549
  • 14
  • 61
  • 83
5
votes
1 answer

How to use SQL 'IN' (or 'ANY') operator with VARRAY in PL/SQL

My .NET code is currently using ODP.NET to call a stored procedure many times to operate on various rows in many tables. The .NET code has an array of the rows to change. Only one parameter changes in each call, and I'd like to pass the array from…
Andy Jacobs
  • 933
  • 3
  • 10
  • 18
5
votes
2 answers

How do I get Oracle.DataAccess.Client?

I am getting this error where Visual Studio 2019 is unable to find Imports Oracle.DataAccess.Client I have downloaded https://www.oracle.com/database/technologies/odac-downloads.html and…
software is fun
  • 7,286
  • 18
  • 71
  • 129
1 2 3
…
88 89