PowerBuilder provides the following Oracle database interfaces. These interfaces use different DLLs and access different versions of Oracle.
|
Oracle interface |
DLL |
|---|---|
|
O10 Oracle 10g |
PBO10190.dll |
|
ORA Oracle (for 11g, 12c, 18c, and 19c) |
PBORA190.dll |
The ORA database interface allows you to connect to Oracle 11g/12c/18c/19c servers using Oracle 11g/12c/18c/19c Database Client or Oracle 11g/12c/18c/19c 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 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 Oracle 10g servers.
