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

ODP.Net Managed API - Array Binding with strings > 1000 characters

When using the ODP.Net managed API, when using array binding to insert data into a column of type VARCHAR2(4000), and a string length of a row value in our array is greater than 1000 characters, the following exception is thrown: ORA-01461: can…
mservidio
  • 12,817
  • 9
  • 58
  • 84
3
votes
1 answer

NLS environment settings and Oracle Managed ODP.Net

We are migrating from the Unmanaged ODP.Net provider where we relied on that provider to read the NLS_COMP and NLS_SORT Window Environment variables. Managed ODP.Net doesn't/can't access these Environment variables. Is there a setting in the…
Dave Michener
  • 1,058
  • 11
  • 30
2
votes
0 answers

IDbDataParameter - Define Oracle Clob

I have a stored procedure with a CLOB as an input. I'm looking to do a refactor, so my Oracle library is not directly referenced. When I create a parameter from the object, I'm getting back an IDbDataParameter object. Passing a string to it…
Ctznkane525
  • 7,297
  • 3
  • 16
  • 40
2
votes
1 answer

Oracle ODP.NET managed driver and problems with connection pools

I know that this should be a question for Oracle, but there are already four threads in https://community.oracle.com asking the same and they get no answer. Maybe someone in stackoverflow can help me as we are getting MASSIVE problems with the…
Raul
  • 671
  • 1
  • 7
  • 24
2
votes
0 answers

Oracle stored procedure fails when called from ODP.NET

I've got a fairly large and complex Oracle stored procedure (~2200 lines) which I'm able to call successfully from SQL Developer, and executes in 2-3 seconds, using the following: var o_my_data refcursor begin SCHEMA.pkg.get_data(i_p1 =>…
Mun
  • 14,098
  • 11
  • 59
  • 83
2
votes
0 answers

ODP.NET + CLOB = ORA-01461: can bind a LONG value only for insert into a LONG column

I'm in trouble try to insert or update some object into my table with CLOB column. The update command is this: UPDATE TABELA SET descricao=:descricao,icone=:icone,codigo=:codigo WHERE Id = 2 The CLOB column is icone that is an image serialized…
Tiago Schäffer
  • 141
  • 8
2
votes
2 answers

Oracle.ManagedDataAccess with Oracle 8.1.7 DB

Is it at all possible to use Oracle.ManagedDataAccess with Oracle DB v.8.1.7? I've searched for hours, but failed to find a definitive answer anywhere.
Aleksei Omelaienko
  • 568
  • 5
  • 19
2
votes
2 answers

Problems switching .NET project from unmanaged to managed ODP.NET assemblies

I'm trying to switch my .NET project over to the manage oracle to make deployments easier. However I'm getting the following error in my test Win Server 2013 environment: Unable to determine the provider name for connection of type…
Tom Halladay
  • 5,651
  • 6
  • 46
  • 65
2
votes
1 answer

ODP.NET Managed driver throws an exception while connecting to the Oracle Database

Good day, I am developing a c# application which uses NHibernate + ODP.NET Managed Driver, application throws an exception during connection: [06.12.2013 12:29:33:324] NHibernate.Exceptions.GenericADOException : could not execute query at…
Alexanderius
  • 822
  • 11
  • 27
1
vote
3 answers

ODP.NET, Managed reading LONG column results in ORA-01009

I'm trying to get the source of a view in my .net app. To do this, I query DBA_VIEWS: it has a column TEXT with exactly what I need. The type is LONG. If I do it using the Unmanaged driver, everything works as expected. The same code with Managed…
Tymur Gubayev
  • 468
  • 4
  • 14
1
vote
2 answers

ODP.NET and managed connections fail with ORA-12154

I thought the whole point of using ODP.Net Managed Connections, via Oracle.ManagedDataAccess.Core NuGet package, is that you don't need an Oracle client installed in the runtime environment. I find lots of posts about the ORA-12154: TNS:could not…
cdonner
  • 37,019
  • 22
  • 105
  • 153
1
vote
0 answers

Oracle.ManagedDataAccess.Client cannot connect using Windows authentication

We are unable to connect to Oracle 19c using Oracle.ManagedDataAccess.Client and windows authentication. Regular .NET 4.0 apps are able to connect but .NET Core apps are not able to connect (both are using managed driver). Below is the code we're…
xam86
  • 111
  • 1
  • 2
1
vote
1 answer

"ODP.NET, Managed Driver" is failing with System.Data.Common.DbProviderFactories.GetFactory. But "raw" works

Gaaaa. Oracle and DotNet Framework code. I am trying to factory-create a "ODP.NET, Managed Driver" I am getting Unable to find the requested .Net Framework Data Provider. It may not be installed. And I have went to the below extreme to make sure…
granadaCoder
  • 26,328
  • 10
  • 113
  • 146
1
vote
1 answer

Where/How to view the ODP.NET source code?

I have a program I am testing out and I want to view the code "under the hood", specifically the OpenWithNewPassword method (might have to Ctrl+F on the page). Is there something similar to Reference Source from Microsoft that Oracle provides? The…
user94614
  • 511
  • 3
  • 6
  • 26
1
vote
0 answers

Oracle.ManagedDataAccess.Client.OracleException: ORA-01017: invalid username/password; logon denied

I'm experiencing an issue by using ODP.NET version 19.3 (latest Oracle Managed DataAccess available) to connect to Oracle 11g using a Secure External Password Store (SEPS), where the Oracle login credentials are stored in a client-side Oracle…
Nicola C.
  • 2,717
  • 3
  • 18
  • 25
1 2
3
4 5 6 7 8