Shulou(Shulou.com)06/01 Report--

[download the latest version of dotConnect for Oracle]

DotConnect for Oracle (formerly known as OraDirect.NET) is based on ADO.NET technology and provides a complete solution for applications based on Oracle database. It brings a new method for designing the application structure, improves the work efficiency, and makes the development of the database application easier.

This article describes how to use Dotconnect for Oracle to create and use Oracle stored procedures and functions with the help of the OracleCommand class.

There are two general ways to execute stored procedures through OracleCommand.

The first way is to include the procedure call in the PL/SQL block and execute the block by placing it in the OracleCommand.CommandText attribute. In this case, the data returned by the process can be processed immediately in the same block. If the procedure requires some parameters, you should add them to the OracleCommand.Parameters collection. This method is no different from normal command execution.

The second way is to set OracleCommand.CommandType to System.Data.commandType.StoredProcedure. In this case, CommandText should be set to the name of the procedure. The following example shows how to populate a data table using the get-all-depts-proc procedure in the previous section:

one

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.