c#調用預存程序

標籤：mos   ext   store   command   exe   RoCE   arc   acl   char   

建立表

create table test(ID number,NAME varchar2(10),SEX varchar2(4),AGE number,ADDRESS varchar2(200));

建立不帶參的預存程序

create or replace procedure proc1isbegin insert into test(ID,NAME,SEX,AGE) values(1,‘moses‘,‘man‘,25);commit;end;

c#調用預存程序

protected void Button2_Click(object sender, EventArgs e)    {        String oc = ConfigurationManager.ConnectionStrings["conn"].ToString();        OracleConnection conn = new OracleConnection(oc);        conn.Open();        OracleCommand orm = conn.CreateCommand();        orm.CommandType = CommandType.StoredProcedure;        orm.CommandText = "proc1";        orm.ExecuteNonQuery();        conn.Close();    }

 

c#調用預存程序