Home ›
All Tags » Oracle » OracleCommand (RSS)

Browse by Tags

Related Posts

  • regarding connection pooling in oracle for my .net application

    actually we are using microsoft entireprise library for connecting to sql server database which is giving good performance for my application.Here I had a problem for my new application where I am using Oracle database as back end.To increase the performance of my application which library I need to...
    Posted to Oracle (Forum) by shivarlakrishna on 05-12-2008, 12:00 AM
    Filed under: Oracle, oracle PL/SQL parameters excetion handling, OracleCommand, oracleconnection, VS.2005, .net 2.0, asp.net 2.0, c#, data access, web.config

  • Insert not inserting to Oracle db

    Hi, I am just trying to learn ASP.NET but have run into a problem when attempting to insert data into my database. I am using Oracle 10g Express Edition, Visual Studio 2005 and the code is in C#. Here is the code I am using to call the insert statement; string sql = "INSERT INTO offices (office_number...
    Posted to Oracle (Forum) by asp.newtome on 04-23-2008, 12:00 AM
    Filed under: Oracle, Oracle Package, oracle PL/SQL parameters, oracle procedure C#, Oracle Stored Procedures Package SqlDataSource Bind Parameters, OracleCommand, oracleconnection, sql query, VS.2005, asp.net, c#, ConnectionString, data access, insert multiple attachments into Oracle

  • Re: The database DLL 'crdb_oracle.dll' could not be loaded.

    I had the same issue when upgrading a project from Asp.net 1.1 to Asp.net 2.0 The report was built in crystal Reports XI however when I included it in my Asp.net 2.0 project I got this error. The solution for me was to reinstall crystal http://support.businessobjects.com/downloads/service_packs/crystal_reports_en...
    Posted to Oracle (Forum) by Kellem00 on 04-01-2008, 12:00 AM
    Filed under: Oracle, OracleCommand, oracleconnection, VS.2005, .net 2.0, asp.net, asp.net 2.0, 'crdb_oracle.dll' Crystal Reports

  • passing exception result

    Hi, I have stored procedure in ORACLE that inserts record in a table that has a unique-key constraint on 3 columns. I managed to handle the exception correctly in the stored procedure. My problem is at the data access layer (I use enterprise library with executenonquery() ) the number of affected rows...
    Posted to Oracle (Forum) by nomercy007 on 12-13-2007, 12:00 AM
    Filed under: Oracle, OracleCommand, Stored Proceedures

  • Re: How to return result from Oracle stored procedure.

    Hi, Thank you for your reply. I had been using this approach for quiet some time now but there is a question which is striking in my mind: How is the ref cursor clsoed? Is it being handled automatically or do we have to write any code to close the cursor explicitly. Please let me know your comments on...
    Posted to Oracle (Forum) by Ashutosh Bhardwaj on 07-09-2007, 12:00 AM
    Filed under: Oracle, OracleCommand, Using REF cusror with ADO.net

  • Character mismatch exception while using "SQLDataSource" for "GridView" updating Oracle Data Base

    i creat connection easlly and fatch data from oracle and delete also easlly uisng "SQLDataSource" for "GridView" accessing Oracle Data Base but when i wish to do "UpDate" it give me the execption "System.Data.OracleClient.Oracle Exception:ORA-12704:Character Set MisMatch"...
    Posted to Oracle (Forum) by avais2006 on 06-23-2007, 12:00 AM
    Filed under: Oracle, OracleCommand, OracleCommand Error, SQLDataSource, .net, .net 2.0

  • Problem while inserting character Ö using ODP.Net into oracle

    Hi I am facing problem while inserting string 'CH-FERBÖX_A_'. The character 'Ö' is getting converted into 'O' after insertion.The string is being converted into ' CH-FERBOX_A_' after insertion.When I fire same insert statment using sql plus , replacement of character from...
    Posted to Oracle (Forum) by Pankaj Deshnmukh on 06-10-2007, 12:00 AM
    Filed under: Oracle, OracleCommand

  • Parameters in OracleCommand CommandText ?

    Hi I'm really hoping someone can help with this, I am trying to add parammeters to a sql statement that is inside a OracleCommand CommandText. I get them from the queryString initially, I know that in oracle you must put a : before the variable name What would the syntax of MyCommand.Paramters.Add...
    Posted to Oracle (Forum) by aidoco on 05-23-2007, 12:00 AM
    Filed under: Oracle, OracleCommand, .net 2.0, c#

  • Going from SQLServer to Oracle - What do I need to do?

    I currently have an application that uses an SQLServer database. It has been decided that an Oracle database will be used in the production version. I need to update my application so that the connections point to an Oracle database. I have never used Oracle before. A DBA will be creating the database...
    Posted to Oracle (Forum) by KJAK on 05-21-2007, 12:00 AM
    Filed under: Oracle, Oracle XMLElement, OracleCommand, OracleCommand Error, oracleconnection, oraclereader

  • Data Inserting problem

    Hi! I have two tables Address(address_id, street) and Employee(emp_id,address_id,name). // address_id in Employee table is foreign key Here is my stored procedure. CREATE OR REPLACE PROCEDURE address_proc (street in varchar2, name in varchar2) is BEGIN INSERT INTO address VALUES (address_id_seq.nextval...
    Posted to Oracle (Forum) by sthauttam on 05-16-2007, 12:00 AM
    Filed under: Oracle, OracleCommand, Parameters, Stored Proceedures, .net 2.0, c#
Page 1 of 2 (15 items) 1 2 Next >

Contact | Advertise | Ads by BanManPro | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.