+++ 本例演示如何用OracleCommand执行存储过程
++ 首先用PL/SQL Develope建立如下存储过程:
CREATE OR REPLACE PROCEDURE add_AB(aCol ab.a%type, bCol ab.b%type) IS
BEGIN
INSERT INTO AB (a, b) VALUES (aCol, bCol);
END add_AB;
++ 后台代码如下
protected void Page_Load(object sender, EventArgs e)
{
string connStr = "Data Source=ora9; uid=scott; pwd=tiger; unicode=true";
OracleConnection conn = new OracleConnection(connStr);
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "ADD_AB";
cmd.CommandType = CommandType.StoredProcedure;
OracleParameter[] paras = {
new OracleParameter("aCol", OracleType.NVarCh
ADO.NET_第七篇_OracleCommand_05执行存储过程
最新推荐文章于 2021-06-08 11:15:34 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)