Stack Overflow
Stack Overflow

Questions tagged [odt.net]

10 questions
4
votes
1 answer

Oracle Connection in C# - connection string

I'm currently trying to build an application in C# and connecting it to a live db running in Oracle 11g. I have the following connection details Host IP: 10.204.1.3 Port: 1521 DB Name: PROD My source code string connString = "DATA…
Fen Ignacio
  • 111
  • 1
  • 1
  • 7
3
votes
1 answer

Best practices with oracle connection in C #

We use oracle database connection and our class database access does not have a dispose or close. It interferes with something or performance of the application? I saw this example: string oradb = "Data Source=ORCL;User Id=hr;Password=hr;"; …
Fernando Arce
  • 332
  • 2
  • 14
2
votes
2 answers

Oracle Developer Tools (ODT) & Visual Studio 2017 Integration

I need to create ADO.NET model from Oracle 12 DB. We are using VS2017. I've installed ODAC and ODT for VS (2015, since there is no version for 2017) according to recommendations in internet. However, EDMX model creation dialog does not show up…
Alexander
  • 1,152
  • 1
  • 16
  • 18
1
vote
2 answers

Program defensively against ODAC instantclient

I'm trying to isolate the oracle-client to the application by xcopying the instantclient and setting environment-variables for ORACLE_HOME and PATH in global.asax.cs as described here and here, but still get [OracleException (0x80004005): The…
Grastveit
  • 15,770
  • 3
  • 27
  • 36
1
vote
0 answers

'OracleAQRnd.db_Message_type2::text::OracleObjectMappingAttribute' cannot be set to an invalid value of 'text'

I need to do Enqueue and Dequeue messages using UDT in oracle advanced queue in c#. I am using following code. UDT: CREATE OR REPLACE TYPE APPS_GLOBAL.db_Message_type2 as object ( text VARCHAR2(4000 CHAR), text1 …
Pramod Thakur
  • 159
  • 1
  • 2
  • 9
1
vote
1 answer

Oracle developer tools for VS 12c not working with VS 2010

I have a project which is developed in VS 2010 and when I try to update the edmx file it is not at all working. I have uninstalled and installed the ODT many times but nothing is working. while installing also the installation window does not…
Arunprasanth K V
  • 20,733
  • 8
  • 41
  • 71
1
vote
2 answers

How to maintain style formatting when merging two ODT documents together

I am working with the AODL library for C#. So far I have been able to wholesale import the text of the second document into the first. The issue is I can't quite figure out what I need to grab to make sure the styling is also moved over to the…
PTaladay
  • 49
  • 10
0
votes
1 answer

How can I inspect query results in a stored PL/SQL function WHILE they're being executed by an external application?

I'm hitting an issue where a query in a stored procedure appears to be deleting more rows than it should be. This query uses a sub-select to determine which records to delete. For example: DELETE FROM MyTable_gt mt WHERE mt.Id not in (SELECT ot.Id …
Jyclop
  • 469
  • 1
  • 6
  • 15
0
votes
1 answer

Cannot install Oracle tools for Visual Studio

I am trying to install the file ODTwithODAC121021 on a Windows 8.1 VM running on parallels and get the following error message when I run the Oracle universal installer Starting Oracle Universal Installer... Checking monitor: must be configured to…
edd
  • 933
  • 2
  • 11
  • 24
0
votes
3 answers

How do you Send More that 20 Parameters to a Stored Procedure Using ODP.Net?

Switching from Microsofts Oracle Driver to ODP.NET version 10.2.0.100. After changing the data types to OracleDBTypes in a procedure, that worked perficetly using System.Data.OracleClient, the procedure fails if we try and pass in more that 20…
user38349
  • 2,945
  • 9
  • 36
  • 47