A Appendix A

This appendix includes the following:

• Oracle Data Types

• Additional Schemas

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;