Postgres Plus Advanced Server Oracle Compatibility Developer's Guide :
Postgres Plus Advanced Server Oracle Compatibility Developer's Guide
This guide describes the Oracle compatibility features of Postgres Plus Advanced Server. Oracle compatibility means that an application runs in an Oracle environment as well as in a Postgres Plus Advanced Server environment with minimal or no changes to the application code.
Postgres Plus Advanced Server contains a rich set of features that enables development of database applications for PostgreSQL or Oracle. This guide focuses solely on the features that are compatible with Oracle. To learn about all of the features of Postgres Plus Advanced Server, consult the Postgres Plus documentation set.
Developing an Oracle compatible application in Postgres Plus Advanced Server requires special attention to which features are used in the construction of the application. For example, developing an Oracle compatible application means choosing:
● Oracle compatible data types to define the application’s database tables
● SQL statements that are compatible with Oracle SQL
● Oracle compatible system and built-in functions for use in SQL statements and procedural logic
● Stored Procedure Language (SPL) to create database server-side application logic for stored procedures, functions, triggers, and packages
● System catalog views that are compatible with Oracle’s data dictionary
Postgres Plus Advanced Server provides these features.
In addition, for applications written using the Oracle Call Interface (OCI), EnterpriseDB’s Open Client Library (OCL) provides interoperability with these applications.
The remainder of this guide explains each of these areas in more detail.