C#

[OracleObjectMappingAttribute("NAME")]
        public virtual string Name{get;set;}

        [OracleObjectMappingAttribute("ADDRESS")]
        public virtual string Address{get;set;}

        [OracleArrayMapping]
        //[OracleObjectMappingAttribute("AGE")]
        public virtual decimal[] Age { get; set; }
<pre> public virtual void FromCustomObject(OracleConnection objCon, IntPtr objUdt)
        {
            //The FromCustomObject method is used to build an Oracle Object or Collection from a custom object by 
            //setting attribute or element values respectively through the OracleUdt.SetValue method.
            OracleUdt.SetValue(objCon, objUdt, "NAME", this.Name);
            OracleUdt.SetValue(objCon, objUdt, "ADDRESS", this.Address);
            OracleUdt.SetValue(objCon, objUdt, "AGE", this.Age);
        }</pre>
  public virtual void ToCustomObject(OracleConnection objCon, IntPtr objUdt)
        {
            //The ToCustomObject method is used to initialize a custom object from the specified Oracle 
            //Object or Collection by retrieving attribute or element values respectively through the OracleUdt.GetValue method.
            this.Name = ((string)(OracleUdt.GetValue(objCon, objUdt, "NAME")));
            this.Address = ((string)(OracleUdt.GetValue(objCon, objUdt, "ADDRESS")));
            this.Age = ((decimal[])(OracleUdt.GetValue(objCon, objUdt, "AGE")));
        }
[OracleCustomTypeMappingAttribute("SERVICE_VATPADMIN.PERSON_TYPE")]
    public class PersonBOFactory : IOracleCustomTypeFactory 
    {
        public virtual IOracleCustomType CreateObject()
        {
            PersonBO obj = new PersonBO();
            return obj;
        }
    }
 private void btnSaveData_Click(object sender, EventArgs e)
        {
            decimal[] ageArray = { 1, 2, 3 };
                PersonBO objPersonBO = new PersonBO();
                objPersonBO.Address = "Delhi";
                objPersonBO.Age = ageArray;
                objPersonBO.Name = "Mrs.Jhon";

                // Establish the connection with Oracle
                OracleConnection objCon = new OracleConnection("Data Source=VATPD;User Id=SERVICE_VATPADMIN;Password=serV1ce_adkong0n;Persist Security Info=true;");
                objCon.Open(); // Open the connection

                // Insert the Person object into database table
                OracleCommand cmd = new OracleCommand("InsertPerson_Proc", objCon);
                cmd.CommandType = CommandType.StoredProcedure; //Database store procedure

                // Oracle Paramater
                OracleParameter objParam = new OracleParameter();
                //Denotes, we are going to pass a custom object
                objParam.OracleDbType = OracleDbType.Object;            
                objParam.Direction = ParameterDirection.Input;
                // Note: The UdtTypeName is case-senstive - Should be in upper case
                objParam.UdtTypeName = "PERSON_TYPE";
                // Attach custom object as input parameter
                objParam.Value = objPersonBO;

                //Attach parameter to command object
                cmd.Parameters.Add(objParam);

                // Insert the UDT into the table
                cmd.ExecuteNonQuery();
            //}
        }

public abstract class Package
{
   private static readonly int funcLength;
   protected static int FUNC_LENGTH { get {return funcLength;} }

   static Package(int _funcLength)
   {
      funcLength = _funcLength;
   }

   public Package() {}

   ...
}