Supported versions for Oracle

PowerBuilder provides three Oracle database interfaces. These interfaces use different DLLs and access different versions of Oracle.

Table 10-1: Supported native database interfaces for Oracle

Oracle interface

DLL

O90 Oracle9i

PBO90125DLL

O10 Oracle 10g

PBO10125.DLL

ORA Oracle 11g

PBORA125.DLL

Support for the O84 Oracle8i interface was discontinued in PowerBuilder 11.5.

NoteFor more information Updated information about supported versions of Oracle might be available electronically on the Sybase Support and Downloads Web site or in the PowerBuilder Release Bulletin.

The ORA database interface allows you to connect to Oracle 11g servers using Oracle 11g Database Client or Oracle 11g Instant Client. It includes partial support for the XMLType datatype that it maps to the PowerBuilder String datatype. It also supports session and connection pooling, load balancing, the Oracle Client Cache, setting of an application driver name, and access through a proxy. Oracle 11g clients can also connect to Oracle9i or Oracle 10g servers.

The O10 database interface allows you to connect to Oracle 10g servers using Oracle 10g Database Client or Oracle 10g Instant Client. It supports BINARY_FLOAT and BINARY_DOUBLE datatypes and increased size limits for CLOB and NCLOB datatypes. Oracle 10g clients can connect to Oracle9i or Oracle 10g servers; they cannot connect to Oracle8i or earlier servers.