C# and Oracle 11g

public void verify(NBuffer Template)
{


string connectionString = "Data Source=NOSHEEN-HP;User ID=FINAL;Password=database";
if (con.State != ConnectionState.Open)
{
try
{
con = new OracleConnection(connectionString);
con.Open();
MessageBox.Show(con.ConnectionString, "Successful Connection");
OracleCommand oraclecmd = new OracleCommand();

oraclecmd.CommandText = "Select TEMPLATE from REGISTRATION where TEMPLATE " + @template;
oraclecmd.Connection = con;
OracleParameter p1 = new OracleParameter();

p1.ParameterName = "Template";
oraclecmd.Parameters.Add(p1);

OracleDataReader dataReader = oraclecmd.ExecuteReader();
if (dataReader.Read())
{
//Convert the reterived byte template back to NBuffer
}

dataReader.Close();

dataReader.Dispose();
oraclecmd.Dispose();

}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Exception Caught");
}
}
}

I have written this code in C# to retrieve the saved template.. and i am not confirm how to obtain it from database...