Search results matching tags 'Oracle' and 'OracleCommand'

regarding connection pooling in oracle for my .net application

shivarlakrishna — Mon, 12 May 2008 04:00:00 GMT

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 use.whether that library overcome the connection pooling problems of my application.wht r the connection classes and methods that library conatains,which of the classes and methods I have to use to get good perfomance my application.please give brief description about that library so that i can find out the methods and classes of that library easily.......

Insert not inserting to Oracle db

asp.newtome — Wed, 23 Apr 2008 04:00:00 GMT

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, city, address, tel_number) VALUES (45, 'London', 'Tottenham', '2342234234');";
        OracleCommand command = new OracleCommand();

        using (OracleConnection myConnection = new
            OracleConnection(ConfigurationManager.ConnectionStrings[
            "connectionString"].ConnectionString))
        {
            command.CommandText = sql;
            command.Connection = myConnection;

            try
            {
                myConnection.Open();
                command.ExecuteNonQuery();
                myConnection.Close();

            }
            catch (Exception ex)
            {
                 ...
            }
        }

The connection string is;

</connectionStrings>

I have created a function that retrieves data from the database OK which is displayed in a grid view, but when I run the insert nothing is inserted into the database. I don't get any errors and I'm confident that the connection to DB is OK as I have already been able to retrieve data as mentioned, I just dont know if there is something I am missing such as a commit for example? Have looked on the web and tried it a couple of different ways but still can't find a solution.

Any help would be gratefully received.

Regards

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

Kellem00 — Tue, 01 Apr 2008 04:00:00 GMT

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.asp

I installed Crystal Reports XI Release 2 and Crystal Reports for Visual Studio .NET 2005

When installing Crystal Reports XI Release 2 I did a custom install. In this custom install I selected anything that related to oracle.

I'm not 100% sure why I needed to do all this but all I know is that the project ran in Visual Studio 2005 after I had completed this.

Hope this helps anyone who might be unfortunate enough to be getting this error

Oracle Database,enter recored into tables using single query

ranvirthakor — Fri, 15 Feb 2008 05:00:00 GMT

Hi I am having one query that i want to insert datas into multiple tables at a time using only one single query in Oracle.so can any body help me to to the same ?

passing exception result

nomercy007 — Thu, 13 Dec 2007 05:00:00 GMT

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 returned is alway 1 even when the constraint violated and exception catched in the procedure.

Re: How to return result from Oracle stored procedure.

Ashutosh Bhardwaj — Mon, 09 Jul 2007 04:00:00 GMT

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 this.

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

avais2006 — Sat, 23 Jun 2007 04:00:00 GMT

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" and application crashed

Please if any one know how to solve

Re: OracleTable to C# Class

opethema — Wed, 13 Jun 2007 04:00:00 GMT

i have developed this tool myself!

thanks for no help.

Problem while inserting character Ö using ODP.Net into oracle

Pankaj Deshnmukh — Sun, 10 Jun 2007 04:00:00 GMT

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 'Ö' to 'O' did not happen.I am using ASP.Net 1.1.

Actual String : 'CH-FERBÖX_A_'

Value in DB : ' CH-FERBOX_A_' after insertion

does anyone know how to get around this problem ?

Thanks in advance

Help me pls. i wan't code startup and shutdown oracle database with vb.net.

pinkbuff — Thu, 31 May 2007 04:00:00 GMT

Help me pls. i wan't code startup and shutdown oracle database with vb.net.