Oracle Helper is a data access layer (Data Access Application Block) for Oracle Database. This mimics the functionality of SqlHelper but for Oracle database when use with ODP.NET component. This requires ODP.NET installed on the machine where the application is running. You can download the ODP.NET component from Oracle site. Make sure that the version of the ODP.NET component and the Oracle database are compatible. It is useful to execute the PL/SQL Procedures and instant sql statements easily without having knowledge of OPD.NET. It is developed by C#.NET 2.0 and provided as open source and free software with GNU Lesser General Public License . You are encouraged and invited to contribute.

Oralce Helper is an open source project and so naturally relies support from a community of users with a shared interest in the project.  Having trouble using some aspect of it? or Want to know the list of bugs? or Like to receive an email when updates are made or Want to simply provide feedback or ideas for further development? Then Oracle Helper Google Group is the place to go.

[1] Reference the OracleHelper.dll to your .NET project.
[2] Add "ideaBubbling.DataAccess" namespace
[3] For executing simple query against Oracle database, we need the following statement
OracleHelper.ExecuteNonQuery(connectionString, CommandType.Text, "insert into employee(id,name) values (1001,'Charles')");
[4] For executing PL/SQL procedure, we need the following statement
DataSet ds = OracleHelper.ExecuteDataset(connectionString, CommandType.StoredProcedure, "USPGetEmployeeDetail",1001);

If you already had experience with SqlHelper class, you can easily use this OracleHelper because it is the simulation of SqlHelper class. In OracleHelper class has following methods

• 9 overloads for ExecuteNonQuery static methods for executing instant action queries like insert, update and delete as well as PL/SQL procedures with/without maintaining transaction.
• 9 overloads for ExecuteDataset static method for executing resultant query like select and PL/SQL procedures with/without maintaining transaction. The result will be getting as dataset object.
• 10 overloads for ExecuteReader static method for executing the resultant query like select and PL/SQL procedures with/without maintaing transaction. The result will be getting as OracleDataReader object.
• 9 overloads for ExecuteScalar static method for executing the instant queries and PL/SQL procedures with/without maintaining transaction. If the scalar value will be the output of PL/SQL or instant queries, this method is the choice.
• 6 overloads for ExecuteXmlReader static method for executing instant queries and PL/SQL procedures with/without maintaining transaction and result will be the XmlReader object.