PowerBuilder provides three Oracle database interfaces. These interfaces use different DLLs and access different versions of 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.
For 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.