Browse by Tags

Home ›

All Tags » Oracle » OracleCommand » c# (RSS)

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
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#
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#
Re: OracleTable to C# Class

i have developed this tool myself! thanks for no help.

Posted to Oracle (Forum) by opethema on 06-13-2007, 12:00 AM
Filed under: Oracle, OracleCommand, oracleconnection, .net, .net 2.0, c#
Help me pls. i wan't code startup and shutdown oracle database with vb.net.

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

Posted to Oracle (Forum) by pinkbuff on 05-31-2007, 12:00 AM
Filed under: Oracle, Oracle XMLElement, OracleCommand, OracleCommand Error, oracleconnection, oraclereader, VS.2005, .net, .net 2.0, c#