More specifically I want to test whether Oracle ODP.Net is installed on a machine. I want to do this by testing for the HKLM\SOFTWARE\ORACLE\ODP.NET registry key. The actual values used by ODP.Net are stored in HKLM\SOFTWARE\ORACLE\ODP.NET\2.111.6.20 however I assume that this lower level key's name will change as updates are released b...
I like to save different c# data types in a Oracle database (int, decimal, double, string, Guid, …). Does anyone have a table showing what oracle data types to use? I have found tables showing what c# data types to use for different oracle data types but not the other way around. ...
I have an Oracle function GetEmployeeDetails which saves all the employee details into a temporary table TempEmployeeDetails table. I have to call the function followed by a select query on the temporary table. The function call succeeds but the select query throws the following error. "BEGIN :Output := MyPackage.GetEmployeeDetails(" ...
I am using Oracle 11g client, with ODP.NET. I am trying to add conditional Transaction handling. Dim ds As New DataSet() Dim txn As OracleTransaction Dim _beginTransaction as Bolean = true Using conn As New OracleConnection(ConnString) Try conn.Open() If _beginTransaction Then ...
The data access layer in our application is going to be using the UDT functionality of Oracle. We will only be passing UDT objects to and from the database. At the moment, we generate the custom classes using the function provided with ODP.NET (which creates a truly horrible looking class that we really don't want in our codebase). We ...
I'm trying to execute a SQL query through ODP.NET to create a table, but I always get an ORA-00911 'invalid character' error. The Errors object in the exception always has the text "ORA-00911: invalid character\n", even if there are no linebreaks in the SQL query itself. The code I'm executing the SQL is this: using (OracleConnection c...
I'm new in ODP.Net and trying to implement it to our existing system. Currently, we are using OLEDB and using IDataReader interface to read a record from DataReader. However, when we use ODP.Net using the same code logic, no records selected. So, my question is, does Oracle.DataAccess.Client.OracleDataReader (ODP.Net) implements IDataRe...
We're running into a strange error using Oracle Odp.Net (connecting to Oracle 9). The problem is illustrated by the code snippet below. This is the error we're experiencing: ORA-00600: internal error code, arguments: [15419], [severe error during PL/SQL execution], [], [], [], [], [], [] ORA-06544: PL/SQL: internal error, arguments: [...
Does LINQ to SQL support Oracle.ODP? If not, is a similar offering from Oracle available or in the works? ...
Hi all, i need good sample code C# or VB.NET , frk 3.5 for this tasks: Read SQL (Oracle) File from Resources RESX and do: create TAbles, Insert Rows using Oracle ODP.NET Thanks in advance ...
The DBA at my company created a new user/password for an application I am working on. I tested the login using SQL Developer and can connect to the database just fine - all the tables I have access to are there. However, in my application, when I try to use the same credentials to connect using Oracle.DataAccess.dll, the connection fai...
ODP.Net exposes the ability to pass Associative Arrays as params into an Oracle stored procedure from C#. Its a nice feature unless you are trying to use the data contained within that associative array in a sql query. The reason for this is that it requires a context switch - SQL statements require SQL types and an associative array p...
Hi all, I have this type: TYPE tipo_TableVarchar2 IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER; and procedure procedure get_array (p_arr out TableVarchar2 ) is ... OracleParameter param = new OracleParameter(); param.OracleDbType = OracleDbType.Varchar2; param.CollectionType = OracleCollectionType.PLSQLAssociativeArray; param.P...
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...
I have a WCF service that uses ODP.NET to read data from an Oracle database. The service also writes to the database, but indirectly, as all updates and inserts are achieved through an older layer of business logic that I access via COM+, which I wrap in a TransactionScope. The older layer connects to Oracle via ODBC, not ODP.NET. The p...
I've got an app that is built with ODP.NET 2.111.6.20 - all the references in VS are set Specific Version to false, but when I try to run the app on a machine that only has 2.111.6.0, it throws an error saying it can't find the 2.111.6.20 assembly. How can I get my app to run with any version of ODP.NET 2.111? ...
Hey guys, We are having some major performance issues with SELECT queries out one of our databases. Please see the simple procedure and associated code below. In the code the ExecuteReader() method is executing in around 10 seconds on a query returning 30K records. Iterating the Reader takes 2 minutes (even when I am not pumping the ...
My development machine is Vista x64. I am using WCF web services to build web services interfacing to an oracle 10g database. When development started, I could not use VS2008's built-in WCF test tool [WCFTestClient] that launches when you press F5 [Go], on the 32-bit Oracle.DataAccess.dll, because I get System.BadImageFormatException o...
Hi! I know there are several threads and posts regarding this issue in the internet and I've read them (not every article, I have to admit) but none of them did fully satisfy me. My situation: I'm using ODP.net (dll version 2.111.6.0) to access the Oracle DB (version 10 + 11) and a DataReader to retrieve the data (.NET 3.5, C#). Using...
Using Oracle® Data Provider for .NET to generate strongly typed datasets. I could of course fill the entire table, but I would like to learn how to use the Where() extension with a delegate function that should limit number of collected rows based on certain table values. Parameters for Where() extension: (this IEnumerable<CUSTOMERRo...