Oracle8i JDBC Developer's Guide and Reference Release 3 (8.1.7) Part Number A83724-01 |
Library | Service | Contents | Index

## Overview

With Oracle8i release 8.1.7, the Oracle JDBC OCI driver supports PL/SQL index-by tables of scalar datatypes. Table 11-1 displays the supported scalar types and the corresponding JDBC typecodes.

##### Table 11-1 PL/SQL Types and Corresponding JDBC Types

PL/SQL Types | JDBC Types
--- | ---
`BINARY_INTEGER` | `NUMERIC`
`NATURAL` | `NUMERIC`
`NATURALN` | `NUMERIC`
PLS_INTEGER | `NUMERIC`
POSITIVE | `NUMERIC`
POSITIVEN | `NUMERIC`
SIGNTYPE | `NUMERIC`
STRING | `VARCHAR`

Note: Oracle JDBC does not support `RAW`, `DATE`, and PL/SQL `RECORD` as element types.

Typical Oracle JDBC input binding, output registration, and data-access methods do not support PL/SQL index-by tables. This chapter introduces additional methods to support these types.

The `OraclePreparedStatement` and `OracleCallableStatement` classes define the additional methods. These methods include the following:

- `setPlsqlIndexTable()`

- `registerIndexTableOutParameter()`

- `getOraclePlsqlIndexTable()`

- `getPlsqlIndexTable()`

These methods handle PL/SQL index-by tables as `IN`, `OUT` (including function return values), or `IN OUT` parameters. For general information about PL/SQL syntax, see the PL/SQL User's Guide and Reference.

The following sections describe the methods used to bind and register PL/SQL index-by tables.

| Copyright © 1996-2000, Oracle Corporation. All Rights Reserved. |
Library | Service | Contents | Index