Home ›
All Tags » Oracle » odp.net (RSS)

Browse by Tags

Related Posts

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

    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...
    Posted to Oracle (Forum) by row118 on 05-19-2009, 12:00 AM
    Filed under: Oracle, odp.net, delimited list, command types

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

    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...
    Posted to Oracle (Forum) by adityapawar on 09-16-2008, 12:00 AM
    Filed under: odp.net, Oracle, stored procedure

  • Oracle 11G and IIS 7.0

    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,...
    Posted to Oracle (Forum) by FuGoAlberto on 05-07-2008, 12:00 AM
    Filed under: odp.net, Oracle, oracleconnection, tns error ora-12154, asp.net, C# oracle DAL exception

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

    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
    Posted to Oracle (Forum) by pgnanaprakash on 04-20-2008, 12:00 AM
    Filed under: odp.net, Oracle, External component has thrown an exception

  • column datatype in oracle and dataset table

    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...
    Posted to Oracle (Forum) by nomercy007 on 11-01-2007, 12:00 AM
    Filed under: odp.net, Oracle, Parameters, tableadapter, datatype conversion

  • Re: How to connect to Oracle

    Step 1: Install Oracle10 g Release 2 ODAC and Oracle Developer Tools for Visual Studio .NET http://www.oracle.com/technology/software/tech/dotnet/utilsoft.html Step 2: Set Oracle_Home environment. For example: Set Oracle_Home = C:\oracle\product\10.2.0\client_1 Step 3: Create sqlnet.ora and tnsnames...
    Posted to Oracle (Forum) by ecocoma on 08-17-2007, 12:00 AM
    Filed under: odp.net, Oracle

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

    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...
    Posted to Configuration and Deployment (Forum) by Manotas on 10-01-2009, 12:00 AM
    Filed under: Oracle, .net 2.0, VS.2005, odp.net, Oracle.DataAccess, oracle 10g provider for ASP.Net 2.0 Data Access

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

    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...
    Posted to Announcements (Forum) by corelab on 10-06-2009, 12:00 AM
    Filed under: ADO.NET, Provider, Oracle, ODP.NET, oracleclient, dotconnect

  • Data provider for Oracle?

    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?
    Posted to Oracle (Forum) by thakkarnimesh on 01-14-2009, 12:00 AM
    Filed under: odp.net, Oracle

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

    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.
    Posted to Oracle (Forum) by TC02435@emirates on 09-18-2007, 12:00 AM
    Filed under: odp.net, Oracle, .net 2.0, asp.net 2.0
Page 1 of 2 (11 items) 1 2 Next >

Contact | Advertise | Issue Management by Axosoft's OnTime | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.