Hi, I have developed an application that uses Oracle Data Provider for .NET. I copy the application file (.exe) and ODP library (Oracle.DataAccess.dll) on another computer that Oracle client and ODP.NET are NOT installed on. When I run the application, I got the error msg: The type initializer for 'Oracle.DataAccess.Client.OracleConnect...
What is the minimal setup required to be able to deploy a .NET application that talks to an Oracle database? ...
I need to call a number of different procedures within an Oracle package successively within a transaction. In fact, I need to call them about 5000 times. I was wondering what syntax I could use to batch these calls to Oracle, so I only need one round trip. I've tried "PACKAGE.PROCA :1, :2; PACKAGE.PROCB :3, :4, :5;" but I get back OR...
Hi all I'm trying to use a RefCursor as an input parameter on an Oracle stored procedure. The idea is to select a group of records, feed them into the stored procedure and then the SP loops over the input RefCursor, doing some operations to its records. No, I can't select the records inside the SP and thus avoid having to use the RefCur...
I've installed ODP.NET and am using the session state service through Oracle for an ASP.NET website. I tested it, I thought, pretty thoroughly and didn't see any major problems. Some of the users have been complaining of exception errors however when they use the system. I added some extra logging and found out how to reproduce the is...
We're currently using a fully installed oracle client and ado.net via odbc to establish an sql*net encrypted connection to an oracle database. My question is if we can achieve encrypted connections with the instant client and odp.net instead of full client and odbc, too? Thanks in advance! ...
I am working in c# .net 2 (Visual Studio 2005 SP1) attempting to fill a dataset with the results from a select * from table from an Oracle10g database. The .net framework, IDE and database cannot be changed at this client site. I'm connecting using the ODP.net provider the dll version is 2.102.2.20 When I run the fill command I get an ...
Hi, I'm currently using the Microsoft ADO.NET provider for Oracle (System.Data.OracleClient). I'm aware that it is certainly not the best Oracle provider available and that it will soon be deprecated, I should be using Oracle's ODP.NET instead. The reason why I still use the MS provider is because ODP.NET binds parameters by position, n...
I may be asking the wrong question here, I'm willing to change it if so. I have a project that is using the Microsoft.NET Oracle provider (our plan is to change to ODP but we haven't done so yet). I am trying to get this project to build on a windows 2008 (x64) build server. It builds just fine but our unit tests fail when they hit st...
How do you use Launch Conditions in Visual Studio .NET for oracle data provider when set variable in setup web application equal oracle? ...
I'm trying to determine how to specify null as a parameter value in an OracleCommand using the following C# code. I've excerpted the relevant bits, but basically the point is if sal_id comes in with the value 0 it should be stored as null. I've tried Null, "Null", and a couple other things but so far no luck. cmd.CommandText = "INSERT...
Is there a way to run an arbitrary sql script through ODP.NET? I'd like to do something like this: SomeOracleObject.RunFile("myfile.sql"); In other words, I want to obviate the need for sqlplus.exe. ...
see also System.Data.OracleClient namespace discontinued? (Firstly don’t panic yet, System.Data.OracleClient is not being removed by Microsoft yet, however it is not in the client version of .net 4) This use to be possible by using System.Data.OracleClient, however Microsoft has decided to deprecate OracleClient. (OracleClient is the ...
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 PCs) Background This data import application is used by a handful of users at each customer’s site it ...
Hi, I'm using ODP.NET (migrating from Microsoft's provider), and I have got stuck on a stored procedure that returs a refcursor. I have the following PL/SQL procedure (I have changed it a little bit to make it more general): PROCEDURE MyProc(parameter_no1 IN NUMBER, parameter_no2 IN NUMBER, RETCURSOR OUT ret_type ) AS BEGIN OPEN RET...
Hi there, i just have some issues regarding the usage of the latest oracle ODP.NET client , and using it to connect with ASP.NET 2008 and C# to an old Oracle 9i database. As stated in the ODP.NET instalation instructuins it should work, but i'm a litte bit rusty when it comes to configure oracle. The old 9i client has issues for .NET, it...
Hi, I'm using Visual Studio 2008 Express Edition, and I'm trying my hand in developing a small application using Oracle.DataClient. I'm getting the above mentioned error, when trying to connect to the database in the target system. I've added a reference to Oracle ODP.net provider for Oracle 10gR2, and in the target machine I have ...
I'm new to Subsonic and I work primarily with Oracle databases. Can subsonic be used against an Oracle database and does it support the use of Oracle's ODP.NET data provider. If yes, can you point me to a good example? Thanks in advance. Scott ...
I currently have a DataAccess Layer in Vb.Net. I am not too happy with my implementation of both my ExecuteQuery (as DataSet) and ExecuteNonQuery functions. Does anyone have any code that I could see? My code just doesn't look clean. Any thoughts or critiques on it would be appreciated also. Using odpConn As OracleConnection = New Or...
I'm a c# SQL Server developer new to Oracle programming. The code below works for setting cmdText to: "select * from myTable". I'd like to now put this in a stored procedure, I need help with how to write this Oracle stored procedure and get the results into a DataTable in my c# code. Thanks. Code: private DbProviderFactory DbFactory ...