I've been working for some time on an application written entirely in C# that targets Oracle databases. The idea is to provide everything that Oracle SQL Developer does, but faster, with a smaller memory footprint. So far, I'd say I'm 90% there. But I've got one small problem, and it's annoying the $#@!$@ out of me! I'm using ADO.NET ...
I'm debugging a Java App, which connects to Oracle DB via a thin client. The code looks as follows: (i'm trying to simplify the use case here so pardon me if t does not actually comile) Connection conn = myEnv.getDbConnection(); CallableStatement call = conn.prepareCall( "{ ? = call SomePackage.SomeFunction (?)}"); call.regist...
This is a little something I thought I need to share. We had some issues establishing connection to Oracle. We kept getting the ORA-12154 (TNS:could not resolve the connect identifier specified) without any apparent reason. The weirdest thing was that in some application the connection was successfully established, while it kept throwin...
Hi I run this query to read the count of the Records with an output parameter using OracleCommand: var query = "declare MyCount number; begin SELECT COUNT(*) INTO :MyCount FROM T_ISSUE; end;"; this one works fine. But if I split the query into two lines like this: var query = @"declare MyCount number; begin SELECT CO...
Is there a way to tune the Oracle client (InstantClient or the normal one)? We have a software that runs on multiple DMBS (MySQL, PGSQL and MS SQL Server) I'm wondering why the Oracle version of the product consume more resources than the other ones. UPDATE: I'm using the C++ API (OCI). ...
First of all, I've seen this, but I want to ask it in a different way. What Oracle client do you use? I've been using SQL Developer but it has problems. Mainly in speed, which the poster in the question above seemed to like about SQL Developer. I'm looking for a new one, but I don't really know what's out there and is free. I like...
I have received this error after updating to Windows 7 64-bit and then running an existing .NET Website. [InvalidOperationException: Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.] I have only installed the ...
We have a web server with multiple oracle clients on it (8i, 9i, 10g). Both ODP.net 9.x and 10.x (and their oo4o counterparts) components are installed. How do I specify to the web application which Oracle/ODP.net client to use when connecting to the database? ...
Is there a command line utility to modify the tnsnames.ora file for the oracle client? [EDIT] I'm looking for something similar to odbcconf.exe (for editing ODBC connection on windows) to modify the tnsnames.ora file. [EDIT2] I'm using MSBUILD from my automated build script. The MSBuild Community Tasks Project has an AddTnsName task t...
We are in the process of moving from the .NET Microsoft oracle driver to the ODP.NET driver. One of the problems we have had is this error: ORA-12705: Cannot access NLS data files or invalid environment specified We were able to stop the error by modifying the registry and changing the setting (see this question) In our case we chang...
So I'm coming from a position as a SQL Server developer who has written a little bit of PL/SQL way back in the mists of time but effectively knows nothing. I've got a laptop, it's running Oracle. There is a database on the laptop which I need to have a look at and neither I, nor anyone else I can speak to, knows what it's called. I ha...
Hi guys! I have a asp.net web application that connects to a Oracle 10.2g database. If I'm running my site in the Visual Studio 2008 webserver everithing is ok, but when a publish it in IIS a get "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater". I added all the permissions for the ASPNET, Authenticate...
Continuing the discussion about the minimum footprint needed to connect to an Oracle DB from .NET. I've managed to set everything up to work without the installation (just by copying the required files). But when I try to run the code as IIS (7.5) application, I get the following error: [Exception: System.Data.OracleClient requires Orac...
I am using a pretty complex query to retrieve some data out of one of our billing databases. I'm running in to an issue where the query seems to complete fairly quickly when executed with SQL Developer, but does not seem to ever finish when using the OracleDataAdapter.Fill() method. I'm only trying to read about 1000 rows, and the quer...
Heya, I need to set up some SET options in Oracle SQLplus command line program each time I use it, such as SET HEADING OFF and the likes to beautify my results. I found that I always have to input each line separately so Set different options and this is becoming annoying since I need to access it many times a day. I found that there's...
I am trying to use dbdeploy to manage Oracle schema changes. I can run it successfully from the command line to get it to generate my change scripts, but when I try to execute it via the dbdeploy NAnt task running through TeamCity, I get an error: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. I ...
Hello: Some months ago, a colleague of mine installed ODAC 11.106.21 in a server using XCOPY and then he developed many applications that use this client without problems (in test and production windows servers). Past week, I developed an application under ODAC 11.1.07.20. When I asked him to install these new ODAC version using XCOPY ...
Hello, I'm looking to write a command-line program that can execute database scripts against an Oracle server, however the machine the program will be run on may not have an Oracle client installed on it. I also don't want to rely on a language that requires a VM as there's no guarantee that the VM will be installed, so a language like...
I'm working on a Sql Server Reporting Services solution that queries across both a Sql Server data source and an Oracle 10g data source. My dev box is Windows 7 64bit with Sql Server 2008R2 and I'm hosting IIS7 and SSRS on that system for development; using VS.NET for designing the reports. I have been having errors when running the rep...
How to show Popup window in OAF on click of a button (Without using Javascript) I have one OAF page on which i should have button Called "Next" On clicking of this button a new window/page should be displayed with the image stored in database. on clicking on this "Next" button again next image from the database should be displayed on t...