CREATE type person_type AS object (pname varchar2(30), address varchar2(60), age
 number(3)); 

CREATE TABLE person_table 
  ( 
     id     NUMBER(5), 
     person PERSON_TYPE 
  ); 

INSERT INTO person_table 
            VALUES ('123', Person_type ('ABC', 'One Street', '68'));  

"SELECT * FROM person_table;
..... usual open, cmd stuff ....
OracleDataReader objReader = objCmd.ExecuteReader();
while (objReader.Read())
                {
                objPersonBO = (PersonBO)objReader["Person"];
                ...
                }       

string sql = "Insert into Person_Table (ID) Values(@id)";

OracleConnection objCon = new OracleConnection("user id=HR;password=HR;data source=Hummer/XE");
objCon.Open(); 
OracleCommand cmd = new OracleCommand(null, objCon);
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;            
OracleParameter idParam = new OracleParameter("@id", OracleDbType.Int32, 5);
idParam.Direction = ParameterDirection.Input;
idParam.Value = 222;
cmd.Parameters.Add(idParam);

cmd.Prepare();
cmd.ExecuteNonQuery();