CREATE FUNCTION "CYM1 ". "RN " (p1 in number)
return number
is
begin
return p1*5;
end;
创建一个函数
OracleConnection oc=new OracleConnection( "data source=ccserver;User Id=cym1;Password=cym ");
OracleCommand ocmd=new OracleCommand();
OracleParameter op=new OracleParameter( "p1 ",OracleType.Number);
OracleParameter op1=new OracleParameter();
op1.OracleType=OracleType.Number;
op1.Direction=ParameterDirection.ReturnValue;
op.Value=5;
ocmd.Parameters.Add(op);
ocmd.Parameters.Add(op1);
ocmd.Connection=oc;
ocmd.CommandText= "rn ";
ocmd.CommandType=CommandType.StoredProcedure;
oc.Open();
ocmd.ExecuteNonQuery();
oc.Close();
Response.Write(op1.Value.ToString());