public void GuidIsPassedAsPrameterAndReturnedAsOutput()
{
OracleDatabase db = (OracleDatabase)DatabaseFactory.CreateDatabase("OracleTest");
Guid myVal = new Guid("33333333333333333333333333444444");
string spName = "sp_GUIDTEST";
DbCommand dbCommand = db.GetStoredProcCommand(spName);
db.AddInParameter(dbCommand, "vGuidInput", DbType.Guid);
db.SetParameterValue(dbCommand, "vGuidInput", myVal);
db.AddParameter(dbCommand, "vGuidOutput", DbType.Guid, ParameterDirection.Output, "", DataRowVersion.Current, null);
db.ExecuteNonQuery(dbCommand);
Guid outputVal = (Guid)db.GetParameterValue(dbCommand, "vGuidOutput");
Assert.IsTrue(myVal.Equals(outputVal));
}