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