C#调用存储过程和函数

1、调用存储过程

1)存储过程

下面是一个简单的存储过程，调用时更新描述信息

PROCEDURE TEST(p_user_name VARCHAR2)  IS
    BEGIN
         IF p_user_name IS NOT NULL THEN
            UPDATE k_users ku
                SET ku.description='测试'
                WHERE ku.user_name=p_user_name;
         END IF; 
    END;

2)C#调用

 private void btnLogin_Click(object sender, EventArgs e)
        {
            string result=string.Empty;
            string sql = "MY_PUBLIC_PCK.TEST";
            OracleParameter op1 = new OracleParameter("p_user_name", OracleDbType.Varchar2);
            op1.Direction = ParameterDirection.Input;
            op1