Questions tagged [odp.net-unmanaged]

7 questions
1
vote
0 answers

kerberos authentication with ODP.NET unmanaged driver C#.NET

Hi I want to use kerberos authentication with ODP.NET unmanaged driver. I can connect using "SQLPLUS /@UAT_APP" I have developed a simple C# console application targeting to .NET framework 4.6.1 below is the code: DbProviderFactory factory =…
Vishal
  • 11
  • 1
1
vote
1 answer

Message State of Oracle Advanced Queue not updating after Dequeue using ODP.net

I am trying to Dequeue a Message from oracle AQ using ODP.NET by service Once the Service Dequeue the message , that record should not be available for other instances of services ,means it should be locked till transaction is committed or…
Sreenath Ganga
  • 696
  • 4
  • 19
  • 48
1
vote
0 answers

OracleUdt throwing AgrumentException in .NET Application

We are getting following exception while using oracle UDT: ArgumentException: Item has already been added. Key in dictionary:.... at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at…
1
vote
0 answers

"Value does not fall within the expected range" when passing UDT to the stored procedure

Here's my class mapping to an UDT in Oracle (really simple): [OracleCustomTypeMapping("PORTAL_OPS.SHAPEUDT")] public class Shape : IOracleCustomType, IOracleCustomTypeFactory { [OracleObjectMapping("SIDES")] public Int32 Sides { get; set; } …
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…
0
votes
0 answers

ODP.Net 11.2.0.2.0 doesn't support 64 bit Oracle.DataAccess.dll

I am using ODP.Net 11.2.0.1.0 with Oracle product version 11.2 and Oracle.DataAccess.dll 32-bit as it is compatible with ODP.NET 11.2.0.1.0. As my entire application is built on 32 bit, sometimes we observe out of memory exceptions. For resolving…
0
votes
0 answers

Oracle UDT mapping with .Net custom types Package's types mapping issue

I am mapping Oracle user defined types to .Net custom types by Oracle Data access unmanaged assembly. I have followed the article https://www.codeproject.com/Articles/1261430/Calling-Oracles-Stored-Procedures-and-Mapping-User I had applied simple…