ASP.NETÈçºÎµ÷ÓÃoracleµÄº¯Êý º¯Êý·µ»ØµÄÊDz¼¶ûÖµ

ÔÚoracleÀïдÁËÒ»¸öº¯Êý ΪÁ˸üжà¸ö±íÃû ¸üгɹ¦Á˾ͷµ»Øtrue ¿ÉÊÇÎÒÔÚ.csÎļþÀï¸ÃÈçºÎµ÷ÓÃOracleµÄº¯ÊýµÄ
Á˽âµÄ´óÏÀÇë°ï·ÖÏíһϣ¨ÔÚÏߵȣ¡£¡£©

---

up

---

°ï¶¥£¡

---

ÒýÓÃ

C# codeOracleConnection conn=new OracleConnection(strConn);
            conn.Open();
            String addUser="SELECT  MYENCRYPT_DATA('"+pwd+"','123456789') from  dual";
            OracleCommand ?-

¶¥

---

C# code:
OleDbConnection conn=new OleDbConnection(strConn);
conn.Open();
String addUser="SELECT MYENCRYPT_DATA('"+pwd+"','123456789') from dual";
²»ÊÇOracleConnection°É

---

using(OracleCommand cmd=new OracleCommand("",""))
{
cmd.CommandType=CommandType.StoredProcedure;
OracleParameter p1=new OracleParameter("str",OracleType.VarChar,10);
p1.Direction=System.Data.ParameterDirection.Input;
p1.Value="";
OracleParameter p2=new OracleParameter("result",OracleType.VarChar,100);
p2.Direction=System.Data.ParameterDirection.ReturnValue;
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
orcn.Open();