Search results matching tags 'Oracle' and 'odp.net'

Migrate from System.Data.OracleClient in two simple steps with Devart

corelab — Tue, 06 Oct 2009 04:00:00 GMT

Devart offers dotConnect for Oracle – fast and reliable ADO.NET provider for the wide range of users. Our ADO.NET provider is the most compatible with OracleClient. dotConnect allows you to migrate from MS OracleClient just in two simple steps.
As you might know from ADO.NET team blog Microsoft announced deprecation of OracleClient as a part of ADO.NET roadmap and strongly recommended to use third-party ADO.NET providers for Oracle instead of continuing to use Microsoft’s OracleClient for new application development.
We have researched problems, which users may encounter migrating from OracleClient to dotConnect for Oracle and found two major. They are Interface differences and Behavior differences. Devart reduces all them just by 2 simple actions. Almost all differences in the names of the classes, methods, and fields between OracleClient and dotConnect for Oracle were removed. Migration Wizard will solve the problems with the minor differences that still exist so you don't have to learn new interface. All behavior differences will be simply reduced just by inserting one string to your code. As simply as that.
What benefits you have using dotConnect for Oracle? We offer you to choose the best Edition to fit your needs. You need functionality similar to OracleClient — get it for FREE! Choose our FREE Express edition! If you want to develop and deploy database applications with ease or you need some advanced features and all functionality of Oracle — choose one of our Advanced Editions. Their prices start just from $149.95. To learn more, download trial and free editions, or order a license welcome to Devart site: www.devart.com/dotconnect/oracle/.
To read full size article with pictures and examples visit dotConnect's team blog: http://www.devart.com/blogs/dotconnect/?p=67 .
Enjoy simplicity of migration with us! About Devart Devart (formerly known as Core Lab) is a software development company with 11 years of experience on the software market and over 20 thousands of devoted users. We specialize in providing native connectivity solutions as well as comprehensive development and management tools for the most popular databases, including Oracle, SQL Server, MySQL, PostgreSQL, InterBase, Firebird, and SQLite. For additional information about Devart, visit www.devart.com/company/.

Application trying to load Oracle.DataAccess version different than the one in web.config

Manotas — Thu, 01 Oct 2009 04:00:00 GMT

Hi,

I would appreciate any help on the following issue we're facing:

We're putting into production an appication which has been already tested on differents environements (supposed to be similars to the production one), but after configuration, we're getting an exception when loading the Oracle.DataAccess dll, but the thing is that's not the same version defined on the web.config.

Could not load file or assembly 'Oracle.DataAccess, Version=10.2.0.200....

The 10.2.0.200 it not indeed in the GAC, but anyway, the exception's details it's pointing to the folling line on the web.config:

<add assembly="Oracle.DataAccess, Version=9.2.0.401, Culture=neutral, PublicKeyToken=89B483F429C47342"/></assemblies>

I really cannot see what's going on. On the GAC, I can find only the following versions of the Oracle.DataAccess:

9.2.0.401
1.102.2.20
2.111.7.20
2.102.2.20

What else could I check ? I suppose there is any manipulation I could do at the Oracle Client level to force the use of the DLL I wish but I don't want to break anything for other applications running under the same server.....

Does anyone know what are we doing wrong ???? Many thanks in advance

Re: Passing a .NET collection to a Oracle Stored procedure?

row118 — Tue, 19 May 2009 04:00:00 GMT

John this is exactly what I'm trying to accomplish.  The following is pseudocode for my Oracle Stored Proc.

CREATE PROCEDURE SelectFromList 
(
delimitedList varchar2(100);   -- 
--- or 
type TableValues of number; 
AS
BEGIN
    Select * From MyTable Where StoreId in (5,6,7,8) ;
      OR 
   Select * From MyTable where StoreId in (select Storeid from the table input)
END ; 

 --------------------------------------
With passing in the table,  what type of variable and how is it populated from cmd parameters in web page (or app) .

 For instance, can you pass an Oracle Array and will be CAST into table by the Oracle Stored Procedure?

I have parsing code for delimited list. In the case of the string, I want to define a table and on each loop, Insert into the table.

Data provider for Oracle?

thakkarnimesh — Wed, 14 Jan 2009 05:00:00 GMT

For accessing Oracle XE Database in the Visual Studio, do I have to Install Oracle Data Acess Components(ODAC)
and Microsoft Oracle .NET Data Provider(ODP) both, or only the ODP will suffice?

How pass parameters to Oracle Stored Proc using ODP.NET?

adityapawar — Tue, 16 Sep 2008 04:00:00 GMT

Hi,

I have trying to pass parameters to Oracle Stored Procedure using ODP.NET through an ASP.NET application.

I dont get any Compile time error. But when I anm executing nonquery command its returning -1 and nothing is updated to DB.

But when I am using inline query everything works fine.

Please find my code snippet below:

int intOutcome = 0;
        using (OracleConnection orclConnection = new OracleConnection(m_strConnectionString))
        using (OracleCommand orclCommand = new OracleCommand())
        {            
            orclCommand.CommandText = "storepdproc";
            orclCommand.CommandType = CommandType.StoredProcedure;
            orclCommand.Connection = orclConnection;

            //Setting up Userid Parameter
            OracleParameter userid = new OracleParameter("userid",intUserID);
            orclCommand.Parameters.Add(userid);

            //Setting up Userid Parameter
            OracleParameter qid = new OracleParameter("qid", intQID);
            orclCommand.Parameters.Add(qid);

            //Setting up Userid Parameter
            OracleParameter read = new OracleParameter("read",intRead);
            orclCommand.Parameters.Add(read);

            //Setting up Userid Parameter
            OracleParameter write = new OracleParameter("write",intWrite);
            orclCommand.Parameters.Add(write);

            //Setting up Userid Parameter
            OracleParameter delete = new OracleParameter("delete",intDelete);
            orclCommand.Parameters.Add(delete);

            //Setting up Userid Parameter
            OracleParameter admin = new OracleParameter("admin",intAdmin);
            orclCommand.Parameters.Add(admin);

            orclConnection.Open();
            intOutcome = orclCommand.ExecuteNonQuery();

            if (intOutcome == 1)
            {
                //No error
                return true;
            }
            else
            {
                //Errored out
                return false;

            }
        }

thanks in advance

Oracle 11G and IIS 7.0

FuGoAlberto — Wed, 07 May 2008 04:00:00 GMT

Hello .... I have an application server with Windows Server 2008, IIS 7 and Oracle Data Provider 11G. The website was set up. NET 2008 has made reference to the oracle, and to run from the application working properly executes the SQL without problem, but to make the creation of a website The IIS 7, and test its functionality, displays the following error

Could not load file or assembly 'Oracle.Web, Version = 2.111.6.20' or one of its dependencies. The system can not find the file specified.

The problem may be a compatibility between the version of Oracle 11G and IIS 7.0, I do not know if there is an additional component to the IIS 7.0 can recognize the version of Oracle as a provider of data? Please I am attentive to their solutions .... Thank you

"External component has thrown an exception." in ODP.net

pgnanaprakash — Sun, 20 Apr 2008 04:00:00 GMT

Hi,

In my web application I am using the backend as ORACLE and dataprovider as ODP.net. When I try to open the connection, it throws an exception "External component has thrown an exception.". Please help me to resolve this.

Regards,
Prakash

Inserting data into Clob column uning ODP.Net

ksridharbabuus — Tue, 27 Nov 2007 05:00:00 GMT

Hi All,

Is any one used ODP.Net provider to insert data into CLOB data type column in Oracle.

Thanks in advance!!!

column datatype in oracle and dataset table

nomercy007 — Thu, 01 Nov 2007 04:00:00 GMT

Hi all,

I have an Oracle table with column of datatype NUMBER(10). When I add a tabledapter in dataset designer, it creates a table with a column of datatype: system.decimal

I change it to system.int32, but when I use an insert query, the parameter is of decimal format. I changed the type in designer.vb (although it is not recommended) and it worked fine. but after time, it revoked back to decimal.

Am I missing something, or it is just another oracle, .NET misunderstanding?

I would appreciate any feedback,

Thanks,

Is it possible to return both refcursor,string at a time

TC02435@emirates — Tue, 18 Sep 2007 04:00:00 GMT

Hi,

I have a stored procedure with 2 out parameters, one ref cursor and one string.How can I get these into my .NET page? Can I use ExecuteNonQuery and get the values?

Thanks.