This section describes how to create and use Oracle stored procedures and functions with dotConnect for Oracle.

It supposes that you know how to connect to server, how to create the necessary objects on the server, and how to manipulate with the data stored in database tables. The section describes stored procedures using for typed DataSets also supposes that you know how to work with Devart DataSet Wizard.

This section contains the following articles:

• Stored Procedures - General Information
  

  Contains general information about stored procedures and functions and describes how to create them.

• Using Stored Procedures via the OracleCommand Class

  Contains an information about using stored procedures with the help of OracleCommand class.

• Using Package Procedures
  

  Describes approaches of the stored procedure usage when they are included into the Oracle packages.

• Using Stored Procedures in DataSets

  Describes how to generate datasets based on the stored procedures or functions.

• Using Table-Valued Functions

  Describes how to use Oracle table-valued functions - the functions, returning a collection of rows, that can be queried like usual database tables by calling the function in the FROM clause of SELECT statements.

Besides, you may be interested in using ORM solutions which are used for converting data between incompatible type systems in relational databases and object-oriented programming languages. dotConnect for Oracle supports the LinqConnect and Entity Framework ORM technologies, which allow to decrease the amount of code and maintenance required for data-oriented applications. For more information, please refer to Entity Framework and LinqConnect topics.

See Also

Stored Procedures - General Information  | Using Stored Procedures via the OracleCommand class  | Using Package Procedures  | Using Stored Procedures in DataSets