public class OracleType : System.MarshalByRefObject, System.IComparable
'Declaration Public Class OracleType Inherits System.MarshalByRefObject Implements System.IComparable
An OracleType class serves to retrieve metadata. Use OracleType object for getting description information about the type. You can get name of the type, attributes collection and description of the element of the collection by ItemObjectType property.
An OracleType does not have constructor and can be created only by calling static GetObjectType function.
This example demonstrates how to retrieve OracleType object from server and display its elements. To create required type and table and fill it with data you can use the following script:
CREATE TYPE TAddress AS OBJECT ( Country VARCHAR2(30), City VARCHAR2(30), Street VARCHAR2(30), Apartment NUMBER ); 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), 'CLERK'); INSERT INTO EmpObject (Code, Person, Address, Job) VALUES (2, 'JONES', TAddress('USA', 'New York', 'Street', 418), 'MANAGER'); INSERT INTO EmpObject (Code, Person, Address, Job) VALUES (3, 'SCOTT', TAddress('CANADA', 'Ottawa', 'Street', 26),'PRESIDENT'); INSERT INTO EmpObject (Code, Person, Address, Job) VALUES (4, 'MARTIN', TAddress('FRANCE', 'Paris', 'Street', 162), 'ANALYST');
System.Object
System.MarshalByRefObject
Devart.Data.Oracle.OracleType
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2