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

This article mainly introduces "Oracle storage process is what", in daily operation, I believe many people in Oracle storage process is what kind of problem there are doubts, small editor consulted all kinds of information, sorted out simple and easy to use operation methods, I hope to answer "Oracle storage process is what" doubts help! Next, please follow the small series to learn together!

I. Overview

Microsoft. NET Framework Data Provider for Oracle

The Oracle. NET Data Provider ships with the. NET Framework 1.1. If you are using. NET Framework 1.0, you will need to download. NET Managed Provider for Oracle. Regardless of the version, the data provider classes are located in the System.Data.OracleClient namespace. lOLEDB l "Provider=OraOLEDB.1; Data Source=ds; User ID=system; Password=manager"

ADO. NET data for picture description

Instructions for ADO. NET Database Usage

Details ADO. NET connection database instructions

Effective explanation and analysis of ADO. NET class library

Details ADO. NET applications for use

Microsoft. NET Framework Data Provider for Oracle is a component of the. NET Framework. Oracle stored procedures provide great convenience for us to access Oracle databases using. NET. l The design of this component is very similar to the Microsoft. NET Framework Data Provider for SQL Server built into. NET l Add System.Data.OracleClient.dll references

II. Introduction to Core Category

The namespace used for organizational classes and other types in l. NET for Oracle components is System.Data.OracleClient. In this namespace, there are four core classes: OracleConnection, OracleCommand, OracleDataReader, OracleDataAdapter. l Oracle stored procedures and functions can be executed using a subset of classes in the System.Data.OracleClient namespace. The specific usage method is almost identical to SqlConnection, SqlCommand, SqlDataReader and SqlDataAdapter. l Add the using System.Data.OracleClient namespace

OracleConnection object

3. Executing Oracle Stored Procedures

Executing Oracle stored procedures is similar to executing SQL Server stored procedures. lOracle stored procedures cannot return a value as part of a RETURN statement, but only as an OUT parameter. l You cannot return a result set other than outputting parameters via REF CURSOR. l You can only retrieve the return value of an Oracle function using the RETURN parameter l The following steps describe how to execute an Oracle stored procedure and retrieve the results it returns.

1. Create a stored procedure named COUNT_JOB_HISTORY in the HR schema to count the number of records in the JOB_HISTORY table.

2. Add a reference to System.Data.OracleClient.dll, the Microsoft. NET Framework data provider for Oracle, to your project.

3. Use the using directive to import types from the OracleClient class. using System.Data.OracleClient;

4. Create an OracleConnection object. OracleConnection conn = new OracleConnection("Data Source=oracledb; User Id=UserID;Password=Password;"); Replace the Oracle database name, username, and password with your values.

5. Create an OracleCommand object. Set its Oracle stored procedure to the connection created in step 4. Set its CommandText to the name of the stored procedure and its CommandText property to CommandType.StoredProcess. When you invoke one of the Execute() methods described in step 8, the command object executes the specified stored procedure.

OracleCommand cmd = new OracleCommand(); lcmd.Connection = conn; lcmd.CommandText = "COUNT_JOB_HISTORY"; lcmd.CommandType = CommandType.StoredProcedure;

At this point, the study of "how Oracle stored procedures are" is over, hoping to solve everyone's doubts. Theory and practice can better match to help you learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!

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.