Oracle执行多条语句,语句间需要用“;"分开执行;如果有返回值时,需要定义返回参数 C#代码int newID = -1;//执行insert语句string sql ="begin " + " INSERT into Users (ID,LoginId, LoginPwd, Name, Address)" + "VALUES (SQU_USERS.nextval,:v_LoginId, :v_LoginPwd, :v_Name, :v_Address)";//查询出最新序列值//sql += ";select SQU_USERS.currval into :v_id from dual;end ;";//或者返回最新序列值sql += " return ID into :v_id; end;";OracleParameter[] para = new OracleParameter[] { new OracleParameter("v_LoginId", user.LoginId), new OracleParameter("v_LoginPwd", user.LoginPwd), new OracleParameter("v_Name", user.Name), new OracleParameter("v_Address", user.Address),//定义输出参数 new OracleParameter("v_id",OracleType.Number,0,ParameterDirection.Output,"ID",DataRowVersion.Current,false,newID)};//执行语句int newId = DBHelper.GetScalar(sql, para);//从参数列表中查找输出参数的值newID =Convert.ToInt32( para[8].Value);... ...