Devart Forums

Code: Select all

using (UniConnection testConnection = new UniConnection("Provider=Oracle; Host=<HOST>; User Id=<User Id>; Password=<PASSWORD>; Home=<Home>; Run Once Command=\"ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN'\";"))

Code: Select all

CREATE OR REPLACE TYPE SEMENB.TAddress AS OBJECT (
  Country VARCHAR2(30),
  City VARCHAR2(30),
  Street VARCHAR2(30),
  Apartment NUMBER,
  offset TIMESTAMP(6) WITH TIME ZONE
);

CREATE TABLE EmpObject (
  Code NUMBER PRIMARY KEY,
  Person VARCHAR2(40),
  Address TAddress,
  Job VARCHAR2(9)
);

INSERT INTO EmpObject (Code, Person, Address, Job) VALUES (1, 'SMITH', TAddress('UK', 'London', 'Street', 12, '07-AUG-2017 2:00:00 PM +6:00'), 'CLERK');

INSERT INTO EmpObject (Code, Person, Address, Job) VALUES (2, 'JONES', TAddress('USA', 'New York', 'Street', 418, '09-AUG-2017 2:00:00 PM -04:00'), 'MANAGER');

Code: Select all

OracleConnection connection = new OracleConnection("your connection string");
OracleCommand command = new OracleCommand("SELECT * FROM EmpObject", connection);
connection.Open();
OracleDataReader dataReader = command.ExecuteReader();
int index = dataReader.GetOrdinal("Address");
while (dataReader.Read())
{
    OracleObject oraObj = dataReader.GetOracleObject(index);
    if (!oraObj.IsNull)
    {
        string country = (string)oraObj["Country"];
        string city = (string)oraObj["City"];
        string street = (string)oraObj["Street"];
        decimal Apartment = (decimal)oraObj["Apartment"];
        Console.WriteLine(oraObj["offset"].GetType()); //System.DateTime
        OracleTimeStamp offset = (OracleTimeStamp)oraObj.GetOracleValue("offset");
        Console.WriteLine(offset.TimeZoneOffset);
    }
}
connection.Close();