Skip Headers
Oracle® Objects for OLE Developer's Guide
10g Release 2 (10.2)

Part Number B14309-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

A Appendix A

This appendix includes the following:

Oracle Data Types

The following are code for Oracle data types.

Table A-1 Oracle Data Type Codes

Oracle Data Type Codes
ORATYPE_VARCHAR2 1
ORATYPE_NUMBER 2
ORATYPE_SINT 3
ORATYPE_FLOAT 4
ORATYPE_STRING 5
ORATYPE_DECIMAL 7
ORATYPE_LONG 8
ORATYPE_VARCHAR 9
ORATYPE_DATE 12
ORATYPE_REAL 21
ORATYPE_DOUBLE 22
ORATYPE_UNSIGNED8 23
ORATYPE_RAW 23
ORATYPE_LONGRAW 24
ORATYPE_UNSIGNED16 25
ORATYPE_UNSIGNED32 26
ORATYPE_SIGNED8 27
ORATYPE_SIGNED16 28
ORATYPE_SIGNED32 29
ORATYPE_PTR 32
ORATYPE_OPAQUE 58
ORATYPE_UINT 68
ORATYPE_CHAR 96
ORATYPE_CHARZ 97
ORATYPE_BFLOAT 100
ORATYPE_BDOUBLE 101
ORATYPE_CURSOR 102
ORATYPE_ROWID 104
ORATYPE_MLSLABEL 105
ORATYPE_OBJECT 108
ORATYPE_REF 110
ORATYPE_CLOB 112
ORATYPE_BLOB 113
ORATYPE_BFILE 114
ORATYPE_CFILE 115
ORATYPE_RSLT 116
ORATYPE_NAMEDCOLLECTION 122
ORATYPE_COLL 122
ORATYPE_TIMESTAMP 187
ORATYPE_TIMESTAMPTZ 188
ORATYPE_INTERVALYM 189
ORATYPE_INTERVALDS 190
ORATYPE_SYSFIRST 228
ORATYPE_TIMESTAMPLTZ 232
ORATYPE_SYSLAST 235
ORATYPE_OCTET 245
ORATYPE_SMALLINT 246
ORATYPE_VARRAY 247
ORATYPE_TABLE 248
ORATYPE_OTMLAST 320
ORATYPE_RAW_BIN 2000

These codes are also listed in the oraconst.txt file located in the ORACLE_BASE\ORACLE_HOME\oo4o directory.

Additional Schemas

Occasionally other schemas are required to run examples. These schemas are listed in the following sections.

Schema Objects Used in OraMetaData Examples

This section presents OraMetaData schema definitions.

CREATE TYPE ORAMD_ADDRESS AS OBJECT ( no NUMBER, 
                   street VARCHAR(60), 
                   state CHAR(2), 
                   zip CHAR(10), 
MEMBER PROCEDURE ChangeStreetName(newstreet IN VARCHAR2) 
); 

Schema Objects Used in LOB Data Type Examples

The following schema objects are used in the OraLOB and BFILE examples. Run the SQL script ORAEXAMP.SQL on your database to set up the schema.

CREATE TABLE part ( 
                   part_id NUMBER, 
                   part_name VARCHAR2(20), 
                   part_image BLOB, 
                   part_desc CLOB, 
                   part_collateral BFILE 
); 
 
Create Directory NewDirectoryName as 'C:\valid\path' 

Schema Objects Used in the OraObject and OraRef Examples

The following schema objects are used in the OraObject and OraRef examples. Data for the following tables can be inserted with the ORAEXAMP.SQL script that is provided with the OO4O installation.

CREATE TYPE address AS OBJECT (
                        street VARCHAR2(200),
                        city VARCHAR2(200),
                        state CHAR(2),
                        zip VARCHAR2(20)
);
 
CREATE TYPE person as OBJECT( 
                        name VARCHAR2(20), 
                        age NUMBER,
                        addr ADDRESS);
 
CREATE TABLE person_tab of PERSON;
CREATE TABLE customers(
                        account NUMBER,
                        aperson REF PERSON);

Schema Objects Used in OraCollection Examples

The following schema is used in examples of OraCollection methods

CREATE TYPE ENAMELIST AS VARRAY(20) OF VARCHAR2(30);
  CREATE TABLE department (
    dept_id NUMBER(2),
    name VARCHAR2(15),
    ENAMES ENAMELIST);

    DROP TYPE COURSE;

  CREATE TYPE Course AS OBJECT (
    course_no NUMBER(4), 
    title VARCHAR2(35),
    credits NUMBER(1));

  CREATE TYPE CourseList AS TABLE OF Course;

  CREATE TABLE division (
    name VARCHAR2(20),
    director VARCHAR2(20),
    office VARCHAR2(20),
    courses CourseList) 
  NESTED TABLE courses STORE AS courses_tab;